I have spreadsheet with same values in the cells. Now i need to find and highlight these values. How to do the same.
iPhone 15 Plus, iOS 17
Hi Styesh,
To find duplicates,
Formula in C2 is COUNTIF(B$2:B2,B2)
Fill down.
To highlight, the simple way is to highlight the values in Column C that are greater than 1
Regards,
Ian.
There is no command like that in Numbers. If it is necessary for you to do it in one step and if Excel has that capability in the iOS version, I recommend you use Excel.
If the duplicates are in a single column, in Numbers you can filter to show duplicates, delete the ones you want to delete (leaving one of each), then remove or turn off the filter. It is far from a one-command operation.
thank and appreciate the same.
but I don’t think so it is find all duplicates as we do in single command in MS Excel.
Actually i have many same entry in xls sheet and its in my iPhone now. Now i need to highlight these entries which are repeated in single shot of command. Pls describe if any method in number app.
Find & highlights the same cell value as duplicate in number sheet
