Count if issue and row

[jw01]

hi all

i have multiple listing of city names in column I13:I5402

the city are listed in alphabatical order and listed multiple times (some cities 10 times, some 120+ times).

i want the first time a city name appears to assign a value of 1 ; everytime a city name repeats to do row above + 1 (only if the city is the same)

i have listed example in column U.

this is my formula in column T, but it's not working right?

Please Login or Register  to view this content.

i know i said "row above +1" but it's supose offset one or something?

can someone pls assist?
thxs

[AliGW]

In T13 copied down, this is all you need:

=COUNTIF(I$13:I13,I13)

[Shareez Saleem]

=countif($i$13:$i$5402,i13)-(countif(i13:$i$5402,i13))+1

[jw01]

worked like a charm...thanks