Thread: Help with IF numbers match in same column

Hi all

Thanks in advance for your help! I'm having a problem getting the following scenario to work:

I'd like to check a column for a duplicate number. If a duplicate is found then I want a result of 0, if a duplicate is not found then I want a result of 1. I feel like this should be really simple, but I just can't get it to work. This is my formula at the moment (where E16 to E26 is the column of numbers:

=IF(E16=E17:E26,0,1)

It's not working. I've also tried the following:

=IF(MATCH(E16,E17:E26,0)>=1,0,1)

This half worked, in that if the number was duplicated, the correct result was generated (0). However, if the number isn't duplicated, the result was given as #N/A (instead of 1)

Any suggestions will be much appreciated.