Getting Duplicates

F

Francois

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.
 
B

Bernie Deitrick

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
 
Top