PDA

View Full Version : mark duplicate row with condition



wping
04-09-2010, 03:19 AM
Hi All,
I need some help. so I've duplicated row in excel below

1 31/12/2009----A
1 01/01/2010----B

I need to keep of one of max date (01/01/2010--B) and how i do for mark A to duplicate.
Thank in advance

Bob Phillips
04-09-2010, 03:32 AM
Where is there a duplicate there, they are totally different?