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: 256

Filed under:

vba

|

field

|

duplicate

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

Tutoriel VBA/VB6 : Les extensions OpenGL en VBA et VB6, par Thierry Gasperment (Arkham46)

as seen on Developper.com - Search for 'Developper.com'
Bonjour à tous! Voici un article sur la programmation des extensions OpenGL, en VB6/VBA Cet article décrit l'utilisation de quelques extensions fréquemment utilisées : - Les VBO (vertex buffer objects) pour améliorer les performances - Les textures 3D pour réaliser des textures continue sur… >>> More
VBA : Obliger une saisie numérique dans une TextBox - Approche d'une résolution de besoin en VBA niv

as seen on Developper.com - Search for 'Developper.com'
Bonjour, Ci-dessous, le lien vers un nouveau tutoriel : « Approche d'une résolution de besoin en VBA - niveau débutant - Obliger une saisie numérique dans une TextBox » Le but de ce tutoriel est : De présenter une bonne approche de la résolution d'un problème simple en VBA. D'expliciter en… >>> More
Run VBA macro when condition is met

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello all, I'm creating a spreadsheet to train my numerical skills. Now, I use VBA macros to generate a new problem once the current one has been correctly solved. To do so, I still have to press a button in the worksheet, which costs time and is annoying. Is there a way that I can execute a… >>> More
Offset the tickmarks of a secondary axis

as seen on Super User - Search for 'Super User'
I would like to offset the tickmarks of a secondary axis in excel WITHOUT changing the minimum. Here is a very complicated VBA class that apparently solves the issue but I would like a solution that doesn't require me to construct my entire chart in VBA. Here is an example of what I mean (I removed… >>> More
Excel 2007 VBA macros don't work in Parallels

as seen on Super User - Search for 'Super User'
I've got a complex Excel spreadsheet I need to use at work. My colleagues use the spreadsheet on Windows PC's, with no special configuration required. I want to run it on a MacBook Pro running Snow Leopard. The spreadsheet contains VBA macros which connect to external Oracle db's over the Internet… >>> More

Related posts about field

How can I convert XML files to one CSV file in C#?

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a collection of strings that are XML content. I want to iterate thru my collection and build a CSV file to stream to the user for download (sometimes it can be hundreds in the collection). This is my loop: foreach (string response in items.Responses) { string xmlResponse = response; … >>> More
CSS: move a "float:right" element to top (to align with the first element of the list)

as seen on Stack Overflow - Search for 'Stack Overflow'
hi, I've a sequence of elements and the last one has css "float:left". I would like to display it at the same height of the first element and not on the bottom of the list. (I cannot change the html code, so it is the last in the list). At the same time, I would like to keep it on the right. How… >>> More
MySQL field type for a comments field or text area

as seen on Stack Overflow - Search for 'Stack Overflow'
As the title says, I'm after a good field type for a comments field I have in a table. It will store many characters (as users can continuously add to it) so it's definitely over 255. I looked at longtext but wasn't sure...Also how do I change the field type to accept different characters such as… >>> More
XML String into a DataGridView (C#)

as seen on Stack Overflow - Search for 'Stack Overflow'
I am currently working with a webservice to pull a report about users in a remote support system. After pulling my report and receiving the result, I am given the following string back by the method: <report><header><field id="0">Source</field><field id="1">Session… >>> More
How to convert many-to-one XML data to DataSet?

as seen on Stack Overflow - Search for 'Stack Overflow'
I have an XML document that has a collection of objects. Each object has a key/value pair of label and value. I am trying to convert this into a DataSet, but when I do ds.ReadXml(xmlFile), then it creates two columns: label and value. What I would like is to have a column for each "label" and the… >>> More