Hi,
I am trying to find a function like is in Excell, it's called duplicate values. So I have sort of names, emails, date of birth etc. each in one column and I need to see if there are any duplicities. I will delete them manually but I need to see them. I am working with a database about 100 people and it is impossible to do it row by row in that case. Any helps?
Thank you, Daniel
MacBook Air, iOS 10.3.2
I use this Flag Duplicates Automator Service (Dropbox download).
I select the cells (for example a range within a table, or a whole column) that might contain duplicates and then choose Flag Duplicates from the Numbers > Services menu. Duplicates are turned red.
To install (it takes less than a minute) simply double-click the downloaded package then enable Automator.app at System Preferences > Security & Privacy > Privacy > Accessibility.
SG
You can do this by creating a new column, then putting a formula in there that compares the values in that row with the row above it.
For instance, say column A is name, column B is email, column C is birthday. Sort the whole table by A, B, C. This way duplicates are in adjacent rows. Now in cell D3, use a formula like:
AND(A3=A2,B3=B2,C3=C2)
This will return TRUE if the cells in A3, B3 and C3 are the same as A2, B2 and C2. Copy and paste that into all cells in column D. Though you can ignore D2, since it is the first row and doesn't have one above it to compare to (I am assuming row 1 is the header row).
You can then use conditional highlighting to turn the cells in column D to red or something if TRUE, so you can spot them easily. Or, copy all of the cells in D and use Edit, Paste Values to make the TRUE/FALSE a real value and not the result of a formula. Then you can sort by column D only, and delete all of the TRUE values.
numbers - duplicate values
