see if duplicates

Please help

is there a way to see if a column has duplicates through an equation when there are 7000 numbers?

MichaelTCA

@Please help You can use a COUNTIF function.

=COUNTIF([Primary Column]:[Primary Column], [Primary Column]@row)

This will tell you how many of that cell is contained within the specified range.

No matter where you are in the list, the result will be the same per duplicate.

MichaelTCA

@Please help You can use a COUNTIF function.

=COUNTIF([Primary Column]:[Primary Column], [Primary Column]@row)

This will tell you how many of that cell is contained within the specified range.

No matter where you are in the list, the result will be the same per duplicate.

Jeff Reisman

@Please help

Can you provide some more information and/or a screenshot?

There is a fairly simple formula to count the number of instances of a value in a column, but I'm unsure what you mean by "through an equation when there are 7000 numbers".