I have the following data PS Lat Long SLOT abc 75.8233 26.2454 1 abc 75.4785 26.4589 1 abc 75.5495 26.4679 1 abc 75.4875 26.8997 2 abc 75.5649 26.7268 2 abc 75.5666 26.8647 2 xyz 75.4875 26.3842 1 xyz 75.4937 26.5877 1 xyz 75.8473 26.3971 1 .... ............. ............. .. Now I want a new column which shows the distances in the following way: All the points with PS=abc and Slot=1 should have their distances calculated from the first point of this group(i.e., 75.8233 26.2454), similarly all the points with PS=abc and Slot=2 should have their distances calculated from the first point of this group(i.e., 75.4875 26.8997) and so on. So please suggest me a solution for this. Also the points should not be entered manually, a programmable solution is needed.
... View more