| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
auto increase number if number is double or more
This is what I'dd like to do
1000 1000 2000 3000 3000 3000 have to become 1000 1 1000 2 2000 1 3000 1 3000 2 3000 3 etc... Kind regards |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
auto increase number if number is double or more
In B2, =IF(A2=A1,B1+1,1) , and copy down
-- David Biddulph "chapeau_melon" wrote in message oups.com... This is what I'dd like to do 1000 1000 2000 3000 3000 3000 have to become 1000 1 1000 2 2000 1 3000 1 3000 2 3000 3 etc... Kind regards |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
auto increase number if number is double or more
Excellent thank you very much for the quick reply
|
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
auto increase number if number is double or more
On Mar 26, 6:55 am, "chapeau_melon" wrote:
Excellent thank you very much for the quick reply A formula like this: =COUNTIF($A$1:A1,A1) might also work for you, although if your data was not sorted, ie something like this: 1000 1000 2000 3000 3000 2000 3000 The 2nd occurrence of 2000 might not give you the answer you wanted (but then again, it might depending on your needs.) |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
auto increase number if number is double or more
Not sure whether you want the 1,2 etc in separate column:
in B1 and copy down =COUNTIF($A$1:A1,A1) will get the 1,2, 3 etc this will combine in a single column : =A1 &" "&COUNTIF($A$1:A1,A1) HTH "chapeau_melon" wrote: This is what I'dd like to do 1000 1000 2000 3000 3000 3000 have to become 1000 1 1000 2 2000 1 3000 1 3000 2 3000 3 etc... Kind regards |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I increase a number by 5.5% and then round that number to the. | Excel Discussion (Misc queries) | |||
| increase number with 1% | Excel Worksheet Functions | |||
| increase the number of columns from 256 to 365 | Excel Discussion (Misc queries) | |||
| number increase by 1 | Excel Worksheet Functions | |||
| Auto number w/ different letter-number combos in same column | Excel Worksheet Functions | |||
Linear Mode
