Hi,

Unique on which fields?

--
Thanks,
Shane Devenshire


"Karen" wrote:

I have worksheet that has around 250 rows with 6 columns. I need to validate
that the data is the same for two rows at a time. How can I highlight any
unique data?

Example:
STR - AD ITEMS 54500000855 01/0003.29 $1.79 02/0003.00
SAP--- AD ITEMS 54500000855 01/0002.99 $1.49 02/0003.00