selecting among duplicated rows in VBA _updated

Posted by Elaine Kuo on Stack Overflow See other posts from Stack Overflow or by Elaine Kuo
Published on 2010-05-25T04:01:34Z Indexed on 2010/05/25 4:11 UTC
Read the original article Hit count: 286

Filed under:
|
|

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

© Stack Overflow or respective owner

Related posts about vba

Related posts about field