Sunday, 8 September 2013

vba code to find Duplicate Values and Newest date(Max) date in the Corresponding Column(cells)

vba code to find Duplicate Values and Newest date(Max) date in the
Corresponding Column(cells)

Friends i'm Creating Macro for "Locating Duplicate values in a Column n
new date(Max date in Corresponding column)....i'm not Getting Logic for
that pls Help me in the Coding...
Data is like this
A B output
3 3/10/2013 5/3/2013
3 5/3/2013
2 10/2/2013 7/7/2013
1 11/10/2013 11/10/2013
4 4/3/2013 6/12/2013
4 6/12/2013
2 7/7/2013
i tried this by sorting even though i'm not getting o/p..pls help me out....

No comments:

Post a Comment