Determine if column contains duplicate value

A

ABM

Is there a way to determine if a column range contains a duplicate value
with a formula in one cell? The formula would return 1 if there are no
repeating values and 0 if a value is found more than once.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function to determine if a cell contains a formula 5
Formula to return desired Result 4
Excel VBA 1
How to determine whether a list contains a specific value? 4
SUMPRODUCT not returning TEXT value 1
Duplicate data 2
Searching alfanumaric cell contents and returning with a numaric v 21
How to determine the values? 1

Top