Hm tried this and it wouldnt work, I am getting a result set like this


Column A---Column B---ROW_NUM_FOR_COL_A
New York----David--------1
New York----John---------2
New York----Alex----------3
Atlanta-------Chris---------1
Florida-------Phil------------1
L.A-----------David---------1
L.A-----------Jenny---------2
L.A-----------Boris----------3
Miami--------Alex------------1
Miami--------Will--------------2

Basically it´s filtering on the last column, and I want to *ASSIGN* row number 1 to New York, 2 to Atlanta, 3 to Florida etc...

:(