How to check double dates in a list?

[atulrajratna]

Hi all,


I am working on a project and srucked on this-

If I have a list of dates as mentioned bellow. And there are some dates which are entered two-three times. But we dont know which they are, How to check those dates in given list?


e.g-

27-Jan-12

12-Feb-12

01-Mar-12

03-Apr-12

21-Apr-12

10-May-12

24-Jun-12

10-May-14

3-Jun-14

27-Jan-12

21-Apr-12


Please help.

Thank you so much!


Atul Rajratna

 

[Montrey]

=COUNTIF($F$3:F3,F3)


Drag down. Any cell that returns 2+ is a duplicate.

 

[Faseeh]

Hi Atul,


Welcome Back!


You can select the column, go to conditional formatting > highlight cell rules > highlight duplicates. and it is done!!


Regards,

Faseeh

 

[Montrey]

If you have 2003. My solution will work.

if you have 2007+ Faseeh will work.

 

[Faseeh]

A variation to Montrey's formula will also work if you place this in conditional formatting option with following formula:

=COUNTIF($A$1:A1,A1)>1

your data is in col A. Works on both 2003 & 2007


Regards,

 

[Montrey]

Always trying to 1 up me Faseeh.


A variation to my formula could be to graph the countif's the decipher where your issues form.

 

[Faseeh]

@ Hi Montrey


hehehehe good to see you back!!