how do I Count repeating numbers in the previous column?
You have change/adjust the cell references to suit your application. The
formula I posted is based on the sample data you posted.
If your data is in the range A2:A1000 then:
=IF(A2=A3,"",COUNTIF(A$2:A$1000,A2))
--
Biff
Microsoft Excel MVP
"Texas Nuckols" wrote in message
...
This worked for the numbers shown. But when I copied it down the next
counts
were 15, 6 and 27, but the formula gave me "0" for each. ???
"T. Valko" wrote:
Try this:
=IF(A2=A3,"",COUNTIF(A$2:A$12,A2))
Copy down as needed
--
Biff
Microsoft Excel MVP
"Texas Nuckols" wrote in message
...
I have this set up:
Market Count
1501
1501
1501
1501
1501 5
1506
1506
1506 3
1507
1507
1507 3
I did this manually for a file of over 1000 lines. Now I need to do
the
same thing for a file of 5000 lines. The file is sorted by "Market".
I
just
need to create a formula that will Count the numbers repeated in column
A
and
put the answer in column B. Can you help?
|