Home |
Search |
Today's Posts |
#1
|
|||
|
|||
adding a number to every change in value
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 |
#2
|
|||
|
|||
B1: =A1&" " & 1
B2: =IF(A2=A1,B1,LEFT(B1,FIND(" ",B1))&RIGHT(B1,LEN(B1)-FIND(" ",B1)+1)+1) -- HTH Bob Phillips "Breinn" wrote in message ... 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 |
#3
|
|||
|
|||
Perfect. You are my Excel hero.
"Bob Phillips" wrote: B1: =A1&" " & 1 B2: =IF(A2=A1,B1,LEFT(B1,FIND(" ",B1))&RIGHT(B1,LEN(B1)-FIND(" ",B1)+1)+1) -- HTH Bob Phillips "Breinn" wrote in message ... 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 |
#4
|
|||
|
|||
I forgot to add ...
and copy down But you knew that :-) Bob "Breinn" wrote in message ... Perfect. You are my Excel hero. "Bob Phillips" wrote: B1: =A1&" " & 1 B2: =IF(A2=A1,B1,LEFT(B1,FIND(" ",B1))&RIGHT(B1,LEN(B1)-FIND(" ",B1)+1)+1) -- HTH Bob Phillips "Breinn" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |