Dear all,
I have an excel file containing two columns: One with Latitude and one with Longitude (they represent the coordinates of point locations). What I want to do is for every unique combination of Lat/Long a unique id number to be assigned in a third, new column. One combination of Lat/Long may apper more that once in the excel file, but every time it appears it will have the same id number. Also the sequence is important. For example if the coordinates of a point are (2,3) id 1 will be assigned to it, but when (3,2) a different id will be assigned to it.
How could I perform that through excel? I also need to tell you that I don't know programming!
Many thanks!
Bookmarks