Sequential Numbers Depending on Another Column

Hi!

I have Cities Name in column B

Cities Name
Aurangabad
Aurangabad
Aurangabad
Aurangabad
Bangalore
Bangalore
Bangalore
Hyderabad
Hyderabad
Hyderabad
Hyderabad
Hyderabad
Hyderabad
Hyderabad
Hyderabad
Hyderabad
Hyderabad
Hyderabad
Hyderabad
Hyderabad
Vijaywada
Vijaywada
Vijaywada
Vijaywada
Vijaywada
Vijaywada


Now what i want to give the Number in column A

Expected Result

S.No Cities Name
1 Aurangabad
2 Aurangabad
3 Aurangabad
4 Aurangabad
1 Bangalore
2 Bangalore
3 Bangalore
1 Hyderabad
2 Hyderabad
3 Hyderabad
4 Hyderabad
5 Hyderabad
6 Hyderabad
7 Hyderabad
8 Hyderabad
9 Hyderabad
10 Hyderabad
11 Hyderabad
12 Hyderabad
13 Hyderabad
1 Vijaywada
2 Vijaywada
3 Vijaywada
4 Vijaywada
5 Vijaywada
6 Vijaywada


Thanks in Advance

Hardeep kanwar

If the city names begin in cell B2:
Enter 1 in cell A2
Enter the following formula in cell A3 then copy it down:

Please Login or Register  to view this content.

Originally Posted by ncmay

If the city names begin in cell B2:
Enter 1 in cell A2
Enter the following formula in cell A3 then copy it down:

Please Login or Register  to view this content.

Perfect!!!!!!!!!!!!!!

Originally Posted by martindwilson

then it wouldnt matter if your list was sorted ,grouped together or not.

Oh Yes,

Both Works Perfect!!!!!!!!!!