Create A Series Of Numbers And Fill It In A Filtered List With Ascending Numbers Assigned

[lmaocopter]

I have 1 column with names, each name repeated 20-50 times. Every row has assigned number ascending randomly 1-99. Must assign in filtered list (eg. 6000/30000 rows) counting numbers from lowest assigned to highest and start counting from scratch when reaches next alphabetical different name. Any idea how to make it? Please help.

 

[Johnny C]

Maybe I don't understand the question, but can't you just select both columns, click Data-Sort and sort on both with name A-Z increasing and number increasing

 

[lmaocopter]

It looks like:

Richard 1
Richard 3
Richard 18
Richard 20
Bob 3
Bob 4
Bob 20
Bob 23

These 2 columns are nearby and i need to do in 3 column series of numbers counting the records of names, starting to count from scratch when it reaches new name. Is it more clear now?

 

[lmaocopter]

ok fixed

 

[Johnny C]

I don't know how you fixed it but if you have lists, COUNTIFS is a great way of keeping running totals - the data doesn't even need to be sorted as the COUNTIFS 'filters' the data on each row separately.