Hi Nitya,

Am Thu, 4 Jun 2015 23:20:18 -0700 (PDT) schrieb Nitya Satheesh:

A B C
1 a 1/5/2012
1 a 1/5/2012
1 a 2/5/2012
1 a 3/5/2012
1 b 2/4/2012
1 b 2/4/2012
1 b 3/4/2012
2 a 3/2/2012
2 a 3/2/2012
2 a 4/2/2012
2 c 5/2/2012
2 c 6/4/2012
3 c 7/4/2012
3 c 8/4/2012
3 c 9/4/2012
3 c 10/4/2012
4 d 3/3/2012
4 d 3/3/2012
4 d 4/3/2012
so for each set of data I need the first date For e.g :
A B C
1 a 1/5/2012
1 b 2/4/2012
2 a 3/2/2012

select one cell of your table = Data = Delete Duplicates and look in
A, B and C.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional