Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have a list of numerical items in column a, with corresponding info in
columns b-ab. I would like to a number to the item number at every change in item. for example I would like to go from this: 10-1000 10-1000 10-1001 10-1001 10-1001 10-1003 to this: 10-1000 1 10-1000 1 10-1001 2 10-1001 2 10-1001 2 10-1003 3 the numbers are variable, as are the number of rows that they occupy. Any thoughts much appreciated. Breinn |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Change colour of Text if number in cell exceed limit | Excel Worksheet Functions | |||
How do I change the invoice number assigned in Invoice template... | Excel Discussion (Misc queries) | |||
How do I change a text fraction. eg 1 1/2 into a decimal number, . | Excel Worksheet Functions | |||
How do you change the date to a Number | Excel Discussion (Misc queries) | |||
EZ Q 4 U: How do I change a number to text, based on the number | Excel Worksheet Functions |