Finding Duplicate Id in more than two rows in a sheet

[mayurpatil]

Hi,

I have a data in which in each sheet i have to find whether The id that are mentioned are present in another row of the same sheet , if present more than once , they can be highlighted.

I am attaching a sheet where month wise Id are mentioned , I want to know whether Id in one month is present in another month.

Thanks in advance,


Mayur

SAMPLE.xlsx

[MarvinP]

Hi mayurpatil,

If you select the entire range of ID's and then do a Conditional Format on the range looking for Duplicates they will light up. See attached.

[Moo the Dog]

You could try selecting cells B6:N466 and apply this conditional formatting formula:

=COUNTIF($B$6:$N$466,B6)>1

- Moo