![]() ![]() With the above instructions, you will quickly and safely highlight duplicate data in Google Sheets, so you will surely improve your work.How to add fonts to Google Slides: step by step guide If the data were in columns A, B and C, the function itself would look like this: =COUNTIF(A:C A1)>1. “A:B A1” because the data I am checking for duplication is in columns A and B and starts in cell A1. ![]() In this case, meanwhile, the formula to use is: =COUNTIF(A:B A1)>1. Once again, the formula to use is =COUNTIF(). After selecting this option, a box will appear for completing the formula based on which duplicate data in the columns will be highlighted. Continue in the same way, select the “Custom formula is” option. To do this again, select “Formatting rules”.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |