Thank you Narayan and daffy333 for your inputs. Assigning unique identifier is really easy, but since I am a beginner in excel its little tough for me.
I should have mentioned my next step as well. The problem is that I cannot delete duplicate records from 800,000 data points before finding...
Hi Chandoo,
I have 800,000 records in three columns with hundreds of duplicate records. Data is not arranged in any particular (ascending or descending) order. For eg:
X Y J
x1 y1 j1
x1 y2 j1
x1 y1 j1
x3 y3 j2
x4 y3 j3
x1 y2 j1
and I want to assign them...