Thread: auto increase number if number is double or more
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default 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



Reply With QuoteReply With Quote