checking for duplicates

[Soondaram]

I want a formula that can tell me if there are duplicates in row. How do I
do?

 

[Norman Harker]

Hi Soondaram!

Take a look at:

Chip Pearson:
http://www.cpearson.com/excel/duplicat.htm#HighlightingDuplicates

You'll find all the formulas you need for handling unique / duplicate
problems.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.