Thank you for sharing. You are Awesome and I am learning a lot from your videos . Your explanation is very clear. Keep up the good work. What I noticed is that in order to hight the entire row this formula can be put in the conditional formatting, namely: =COUNTIF($A$2:$A$17, $A2)>1. The only difference is that I put $ in front of A2. Please check it out.
Super tutorial! This video gives us a visual understanding about how a series of function are applied to range in "Conditional Formatting". It seems to me that it's similar to dragging to a specific cell to other area. :-)
Hi thanks for the video. How we can apply a conditional formatting for every cell. I want to highlight when a cell is same with any other in the same row. I pasted the =COUNTIF($A$2:$A$17, A2) > 1 but when I apply it in the whole column it still tries to catch if ALL THE OTHER are equal to A2 and not itself i.e. A6. Any ideas?
thank you for being so kind and helpful. two questions, i've tried to match the same repeated argument duplicates with different colours and i can't find a way. The other question in about the cells without value,they will appear, so we need to use..if(NOT(ISBLANK(blá blá bla..)?? or we have an other way?
Can you help ? I have created an expense income sheet. When an expense is made by credit care, I would like to the sum to subtract from the row which contains the running credit card balance as well as subtract from the row which contains the overall balance.
Guessing you want empty cells not coloured. Well, I'd simply add a conditional format rule before the one from the video. I think there's a standard rule, otherwise use the ISBLANK() statement. You can also use the latter in the formula when you wrap that in an IF() statement.
thanks, I already knew how to do that, but thought that I was being an idiot bc I couldnt find the option.. Seems that it doesnt exist in google sheets..
your explanation is soo good
Thank you for sharing. You are Awesome and I am learning a lot from your videos . Your explanation is very clear. Keep up the good work.
What I noticed is that in order to hight the entire row this formula can be put in the conditional formatting, namely: =COUNTIF($A$2:$A$17, $A2)>1. The only difference is that I put $ in front of A2. Please check it out.
I used this formula. But it also highlighted those Partial/near duplicates… (countif) do you think i should do?
Very clever methods and use of array functions. Great video, thanks for sharing.
Thank You!
Thank you very much, it has been very useful. Greetings from Peru
Super tutorial! This video gives us a visual understanding about how a series of function are applied to range in "Conditional Formatting". It seems to me that it's similar to dragging to a specific cell to other area. :-)
Thank you, buddy! Cheers from Brazil
I need help with the locking part
I’m pressing f4 but it’s not locking the cell
I can't see the whole countif formula string. After I type the range put a comma what else do I put before I put the criterion?
There is a way to count duplicates by sequence... like 1of5, 2of5, 3of5... so on?
How do you set the criteria for 2 adjacent cells? If you have 2 columns and you want each row to not contain duplicate values in column A vs B
Thank you so much! This video is very helpful.
Great videos !
Thanks a lot
Why do we need a double minus in this expression?
To convert TRUEs and FALSEs to 0's and 1's
Hi thanks for the video. How we can apply a conditional formatting for every cell. I want to highlight when a cell is same with any other in the same row. I pasted the =COUNTIF($A$2:$A$17, A2) > 1 but when I apply it in the whole column it still tries to catch if ALL THE OTHER are equal to A2 and not itself i.e. A6. Any ideas?
=COUNTIF($A:$A, A2) > 1
Can you show us how to do conditional formatting using script to add borders when a date changes? Thank you for your videos
It was very helpful for my work. Thank you for nice tutorial :)
Thank you so much for your videos
finally, a formula that works
it seems to me that this no longer works the same way, and only highlights the first instance of a duplicate
thank you for being so kind and helpful.
two questions, i've tried to match the same repeated argument duplicates with different colours and i can't find a way. The other question in about the cells without value,they will appear, so we need to use..if(NOT(ISBLANK(blá blá bla..)?? or we have an other way?
We can just do =if(A1, “formula” , ) This will check if A1 is not empty, and do the formula, otherwise it’ll do nothing.
@@alexlotion5055 i found it some moths ago, but you are the man! your work with google scripts is amazing ant you explain in a good way.
Can you help ? I have created an expense income sheet. When an expense is made by credit care, I would like to the sum to subtract from the row which contains the running credit card balance as well as subtract from the row which contains the overall balance.
have you looked at SUMIFS function?
NO, I will look. Thanks
You are my savior! Muaaaa
Thanks a lot! Is that method still working? Can we use COUNTUNIQUE for formating duplicates?
yes it should work. you can use any function that returns true or false in the end
awesome bro!...it helped me alot and thanks for sharing.
Google sheets me koi particular word ko search karke uaka count chahiye sabhi sheets ka to kese hoga
very clear. thanks
How to sort all the similar names together ?
thank you!
so useful, thank you
Can I ask, so I did A2:A instead, is there a way for empty cells to
Guessing you want empty cells not coloured.
Well, I'd simply add a conditional format rule before the one from the video. I think there's a standard rule, otherwise use the ISBLANK() statement.
You can also use the latter in the formula when you wrap that in an IF() statement.
how to turn thoose duplicate rows into 1 single row?
thanks, I already knew how to do that, but thought that I was being an idiot bc I couldnt find the option..
Seems that it doesnt exist in google sheets..
Sir, i've been trying to apply this formula the exact same way you did, and it returns as 'invalid parse'. How can i proceed? :/
I did the exact same way and it worked. You probably missing something.
show your example, or your formula, and maybe, i will help you
Why do we need a double minus in this expression?
To your question...exceljet.net/the-double-negative-in-excel-formulas
didn't work for me, until i used semicolon instead of comma between range and criteria...
That's language settings. You'll need to always use semicolons instead of commas. The rest should be the same.
Regional settings, Moscow region? Check it in your Spreadsheet File - Settings Spreadsheet - Locale
Thank you so much, so usefull. I wanna cry now!! T_T
Thanks, but as someone new to formulas of this nature, you lost me at the beginning when you hit F4 for some reason and the formula was added to...
If you're new to this watch beginner level playlist on the channel.
F4 fix inputted range, if you copy this formula to another cell , fixed range dont change. $C$4 - fixed range
What do the two dashes '--' do?
convert TRUE to 1 and FALSE to 0
@@ExcelGoogleSheets So basically this is a NOT() function?!? Cool! :-)
@@marcpennings7881 NOT will reverse trues and falses, this converts them to binary/numbers.
@@ExcelGoogleSheets I just found out myself, but thanks for setting me straight! Much appreciated.
I ran the "duplicates" formula on the list of videos in this playlist and it told me there was two duplicates. How ironic.
🙏🏻
it is not working !!!!!!!!
File - Spreadsheet Settings (General) - Locale: United States
longest video for a 2 min thing, time wasted
very very goodddddddddddd