Are there duplicate cells in my rows?

[btbrennan81]

Hello friends, I have a spreadsheet of more than a thousand rows, each with 10 columns worth of data. For A1:J1267, every cell has content. I want to see in each row whether or not there are any duplicates, and not in the conditional formatting way that makes me have to do each row individually. Is there a formula I could drag down in Column K that would give me a True or False for each row?

Thanks for your help!

[63falcondude]

Assuming headers are in row 1, try this in K2:

=SUMPRODUCT(COUNTIF(A2:J2,A2:J2))>COUNTA(A2:J2)

[btbrennan81]

It worked when the data in the fields were only numbers. Unfortunately, The data in the fields is not always a number, sometimes it is alphanumeric.

[63falcondude]

Did you use COUNT or COUNTA?

[btbrennan81]

I copied and pasted your formula, so COUNTA

[63falcondude]

I originally had COUNT in there but quickly edited it to COUNTA to account for non-numeric entries.

Maybe you copied the original before the edit? The formula that's in there now should account for text as well as numbers.

[Richard Buttrey]

Maybe

Please Login or Register  to view this content.

[btbrennan81]

Both ways worked, thank you both!

[63falcondude]

Happy to help. Thanks for the rep!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

[btbrennan81]

I have marked it solved!