lundi 23 février 2015

Conditionally assign unique values

I have data, for example:



John Doe MD 1
Ben Doe PA
Cal Doe MD 1
Drum Doe PA
Egg Doe NP
Fun Doe MD 1

So everywhere there's an MD I have an IF condition assigning the number 1. But I want to isolate and pull all the names with a 1 consecutively. Example:



John Doe
Cal Doe
Fun Doe

I know I just have to have numeric values such as: john doe-1, cal doe-2, fun doe-3.


I'm having problem with the logic if someone can help I'll appreciate it.


Aucun commentaire:

Enregistrer un commentaire