Hi hui,
It seems my problem hasent been intreperted correctly..
see..
I have 2 columns one with DPIS , and other with Location Desc
I have dates in DPIS and location names in location desc
So, now I have to take out those values were location desc is same , but different dates...
DPIS LOCATION DESC
17-Jan-06 Ambala-Ambala 0
22-Dec-05 Ambala-Ambala 0
22-Dec-05 Ambala-Ambala 1
30-Nov-05 Ambala-Ambala 0
31-Jan-06 Ambala-Ambala 0
31-Jan-06 Ambala-Ambala 1
I need to filter out duplicate entries, like I have to eliminate , same LOcation Desc different dpis...