see Chip Pearson's site for advice on dealing with duplicates:

http://www.cpearson.com/Excel/Duplicates.aspx



"Bob Aloisi" wrote:

Hello, I've got an Excel spreadsheet with a single column. The cells
contain a date & time (m/d/yyyy h:mm:ss). I'd like to compare the value in
cell A2 to A1, then A3 to A2, A4 to A3, etc. to determine if it's a
"duplicate" or "different".

Can you help?

THANK YOU