selecting among duplicated rows in VBA _updated

Question

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 code to implement 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

Answer 1

You can use SQL in VBA.