Google Sheets - Conditional Formatting Duplicate Values Tutorial - Highlight Duplicates

Поделиться
HTML-код
  • Опубликовано: 29 окт 2024

Комментарии • 73

  • @moheuddin_sehab
    @moheuddin_sehab 5 лет назад +7

    your explanation is soo good

  • @iloveutubealotandmor
    @iloveutubealotandmor 6 лет назад +2

    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.

  • @takaakiyamada7294
    @takaakiyamada7294 3 года назад

    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. :-)

  • @omegatrece
    @omegatrece 3 года назад

    Thank you very much, it has been very useful. Greetings from Peru

  • @ReigneChannel
    @ReigneChannel 3 года назад +1

    I used this formula. But it also highlighted those Partial/near duplicates… (countif) do you think i should do?

  • @mikemccartneyable
    @mikemccartneyable 7 лет назад +1

    Very clever methods and use of array functions. Great video, thanks for sharing.

  • @viniciush.4740
    @viniciush.4740 4 года назад +1

    Thank you, buddy! Cheers from Brazil

  • @jayveeolasiman4171
    @jayveeolasiman4171 3 года назад

    Thank you so much! This video is very helpful.

  • @tholodryha
    @tholodryha 6 лет назад +1

    It was very helpful for my work. Thank you for nice tutorial :)

  • @JaredNgesa
    @JaredNgesa 5 лет назад

    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?

  • @onegsm3741
    @onegsm3741 2 года назад

    There is a way to count duplicates by sequence... like 1of5, 2of5, 3of5... so on?

  • @Typethink
    @Typethink 3 года назад

    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

  • @devinabharat8470
    @devinabharat8470 2 года назад

    I need help with the locking part
    I’m pressing f4 but it’s not locking the cell

  • @JBHowTo
    @JBHowTo 4 года назад

    Thank you so much for your videos

  • @aakashsingh3456
    @aakashsingh3456 7 лет назад

    awesome bro!...it helped me alot and thanks for sharing.

  • @johngiftakis9878
    @johngiftakis9878 3 года назад

    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?

  • @jessemunson1352
    @jessemunson1352 5 лет назад

    finally, a formula that works

  • @hubertambrois-geniecivil5275
    @hubertambrois-geniecivil5275 5 лет назад +1

    Great videos !
    Thanks a lot
    Why do we need a double minus in this expression?

  • @susicmelecete8858
    @susicmelecete8858 4 года назад

    very clear. thanks

  • @07darwinmarquez
    @07darwinmarquez 9 месяцев назад

    thank you!

  • @OscarWrightZenTANGO
    @OscarWrightZenTANGO 6 лет назад

    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.

  • @strux
    @strux 5 лет назад

    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?

    • @alexlotion5055
      @alexlotion5055 4 года назад +1

      We can just do =if(A1, “formula” , ) This will check if A1 is not empty, and do the formula, otherwise it’ll do nothing.

    • @strux
      @strux 4 года назад

      @@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.

  • @pennaverdeful
    @pennaverdeful 6 лет назад +1

    Thank you so much, so usefull. I wanna cry now!! T_T

  • @zenzaishi3601
    @zenzaishi3601 4 года назад

    Can I ask, so I did A2:A instead, is there a way for empty cells to

    • @marcpennings7881
      @marcpennings7881 3 года назад

      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.

  • @MichaelDaniels
    @MichaelDaniels 3 года назад

    Can you show us how to do conditional formatting using script to add borders when a date changes? Thank you for your videos

  • @eugenesoft856
    @eugenesoft856 7 лет назад

    Thanks a lot! Is that method still working? Can we use COUNTUNIQUE for formating duplicates?

    • @ExcelGoogleSheets
      @ExcelGoogleSheets  7 лет назад +1

      yes it should work. you can use any function that returns true or false in the end

  • @duyenngo467
    @duyenngo467 3 года назад

    so useful, thank you

  • @raphaelgomes2947
    @raphaelgomes2947 Год назад

    it seems to me that this no longer works the same way, and only highlights the first instance of a duplicate

  • @jasminelegaspi6540
    @jasminelegaspi6540 5 лет назад

    You are my savior! Muaaaa

  • @datumticorp7311
    @datumticorp7311 5 лет назад

    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? :/

    • @mozartips
      @mozartips 5 лет назад

      I did the exact same way and it worked. You probably missing something.

    • @ingooglesheets222
      @ingooglesheets222 3 года назад

      show your example, or your formula, and maybe, i will help you

  • @bintangmuhammad7082
    @bintangmuhammad7082 4 года назад

    how to turn thoose duplicate rows into 1 single row?

  • @delinquense
    @delinquense 3 года назад

    I ran the "duplicates" formula on the list of videos in this playlist and it told me there was two duplicates. How ironic.

  • @Corporatehacker
    @Corporatehacker 6 лет назад

    Google sheets me koi particular word ko search karke uaka count chahiye sabhi sheets ka to kese hoga

  • @james98731
    @james98731 3 года назад

    How to sort all the similar names together ?

  • @danolo24
    @danolo24 4 года назад

    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..

  • @cuneiformscript2665
    @cuneiformscript2665 4 года назад

    🙏🏻

  • @РоманБабушкин-ц1о
    @РоманБабушкин-ц1о 6 лет назад +2

    Why do we need a double minus in this expression?

    • @strux
      @strux 5 лет назад

      To your question...exceljet.net/the-double-negative-in-excel-formulas

  • @jakobj.1813
    @jakobj.1813 7 лет назад +1

    didn't work for me, until i used semicolon instead of comma between range and criteria...

    • @ExcelGoogleSheets
      @ExcelGoogleSheets  7 лет назад

      That's language settings. You'll need to always use semicolons instead of commas. The rest should be the same.

    • @ingooglesheets222
      @ingooglesheets222 3 года назад

      Regional settings, Moscow region? Check it in your Spreadsheet File - Settings Spreadsheet - Locale

  • @hughthenasia3153
    @hughthenasia3153 4 года назад

    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...

    • @ExcelGoogleSheets
      @ExcelGoogleSheets  4 года назад

      If you're new to this watch beginner level playlist on the channel.

    • @ingooglesheets222
      @ingooglesheets222 3 года назад

      F4 fix inputted range, if you copy this formula to another cell , fixed range dont change. $C$4 - fixed range

  • @marcpennings7881
    @marcpennings7881 3 года назад

    What do the two dashes '--' do?

    • @ExcelGoogleSheets
      @ExcelGoogleSheets  3 года назад +1

      convert TRUE to 1 and FALSE to 0

    • @marcpennings7881
      @marcpennings7881 3 года назад

      @@ExcelGoogleSheets So basically this is a NOT() function?!? Cool! :-)

    • @ExcelGoogleSheets
      @ExcelGoogleSheets  3 года назад +1

      @@marcpennings7881 NOT will reverse trues and falses, this converts them to binary/numbers.

    • @marcpennings7881
      @marcpennings7881 3 года назад

      @@ExcelGoogleSheets I just found out myself, but thanks for setting me straight! Much appreciated.

  • @redhaal-obaidy2217
    @redhaal-obaidy2217 4 года назад

    it is not working !!!!!!!!

    • @alexlotion5055
      @alexlotion5055 4 года назад

      File - Spreadsheet Settings (General) - Locale: United States

  • @vincent600
    @vincent600 4 года назад

    longest video for a 2 min thing, time wasted

  • @sawadeebetcasinoonline285
    @sawadeebetcasinoonline285 5 лет назад

    very very goodddddddddddd