how to find duplicates in numbers?

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

in what context?

for what volume of data? is it in a single column, a row, multiple rows and columns?

One way is to sort the data then inspect the data. This is ok for small data sets. There are others depending on how much and what kind of data.

Sarv,

This is a fairly routine question here. The usual answer involves an auxiliary column in which you do a COUNTIF of the column containing the potential duplicates. Any result greater than 1 indicates a dup is present. If the potential duplicated data is in A, you could write:

=COUNTIF(A, A)

That function asks the question: How many times does the value found in column A of this row occur in the entire column A range.

Variations on that simple formula can make it easier to group and delete the duplicates. So, depending what you want to do about the dups, you may have different solutions.

Jerry

Hi Dundees,

This is a really old thread.

Why not start a new thread, giving more specifics of what your data looks like?

A screenshot would be helpful.

SG