| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
adding a number to variables
I have a table that is like this
1 1 1 2 2 3 3 3 3 I would like it to look like this 1 1 1 2 1 3 2 1 2 2 3 1 3 2 3 3 3 4 any easy formula for that? TIA |
|
#2
|
|||
|
|||
|
B1: 1
B2: =IF(A2=A1,B1+1,1) and copy down -- HTH Bob Phillips "Breinn" wrote in message ... I have a table that is like this 1 1 1 2 2 3 3 3 3 I would like it to look like this 1 1 1 2 1 3 2 1 2 2 3 1 3 2 3 3 3 4 any easy formula for that? TIA |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I add the number of variables? | Excel Discussion (Misc queries) | |||
| look up number in column | Excel Worksheet Functions | |||
| What is the formula for adding a number of days to an existing dat | Excel Worksheet Functions | |||
| adding a zero in front of number | Excel Discussion (Misc queries) | |||
| Adding cells, using text as number | Excel Discussion (Misc queries) | |||
Linear Mode
