Thread: counting range
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
saman110 via OfficeKB.com saman110 via OfficeKB.com is offline
external usenet poster
 
Posts: 80
Default counting range

In column A I have numbers. How can I in column B start a count from 1 each
time that I get different number. For example:


What I have:

A

200
200
200
200
788
788
788
922
922
922
922

The result:

A B

200 1
200 2
200 3
200 4
788 1
788 2
788 3
922 1
922 2
922 3
922 4

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200802/1