I wanna select one row of each duplicated SIDs in a field below. (an attribute table of a shape file)
The priority is R S = I 0
Therefore, among SID 87, FID1 will be selected.
(SID 88, STATUS will be S+I)
(SID 89, FID 6 will be chosen)
(SID 90, deleting FID 9 or 10)
Please kindly advise VBA cord to run the selection and thanks.
FID SID STATUS
1 87 R
2 87 O
3 88 I
4 88 S
5 89 I
6 89 R
7 89 I
8 89 S
9 90 S
10 90 S