Getting Duplicates
 

I have a spreed sheet with numerical and text values in. How do i identify
duplicate values in a row Eg. A, C and D. Where the value can appear more
than once in Colum A and again in Cloum C and D. I did try conditional
formatting but i am not gtting it. I can identify duplicates in only row A
with the Coulour of the cell change but not over the whole spread sheet.

Getting Duplicates
 

Select all your cells with your data, and apply CF with the custom function (select the "Formula is"
option)

=COUNTIF(2:2,A2)1

BUT change the 2:2 to reflect the first row of your selection, and change the A2 to the activecell
of your selection. (For example, if you select D12:H100 by clicking first on D12 and shift clicking
H100, then the formula would be =COUNTIF(12:12,D12)1)

HTH,
Bernie
MS Excel MVP


"Francois" wrote in message
...
I have a spreed sheet with numerical and text values in. How do i identify
duplicate values in a row Eg. A, C and D. Where the value can appear more
than once in Colum A and again in Cloum C and D. I did try conditional
formatting but i am not gtting it. I can identify duplicates in only row A
with the Coulour of the cell change but not over the whole spread sheet.