Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
counting range
Put 1 in B1
and =IF(A2=A1,B1+1,1) in B2 and copy down. Rob "saman110 via OfficeKB.com" <u35670@uwe wrote in message news:7fbe56c1fe055@uwe... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
counting range
One way:
Numbers in the range A1:A11 Enter 1 in cell B1 Enter this frmula in B2 and copy down to B11: =IF(A2=A1,B1+1,1) -- Biff Microsoft Excel MVP "saman110 via OfficeKB.com" <u35670@uwe wrote in message news:7fbe56c1fe055@uwe... 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
counting range
In B1: =COUNTIF(A$1:A1,A1)
copy down as far as needed "saman110 via OfficeKB.com" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting from one range to another range, multiple criteria | Excel Discussion (Misc queries) | |||
Counting a range | Excel Worksheet Functions | |||
counting a cell range within a range | Excel Worksheet Functions | |||
counting occurrences in a range | Excel Discussion (Misc queries) | |||
Counting within a filtered range | Excel Worksheet Functions |