Hello everybody,
Here's my problem. I have a huge (25,000 row) spreadsheet with two 'ordered' columns of 6 digit co-ordinate data (eastings and northings). I now want to create a third column which identifies duplicates.
Essentially, what I want to do is each time column-A and column-B are duplicated in a series of rows, then create unique flag in the third column...
e.g.
123456, 989876, 1
123456, 989876, 1
765432, 343232, 2
456543, 686843, 3
456543, 686843, 3
456543, 686843, 3
675423, 776453, 4
282864, 966572, 5
282864, 966572, 5
282864, 966572, 5
...etc
Any help much appreciated,
Many thanks,
Helen
Bookmarks