Need formula for frequency subtotals

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have column sorted numbers 1...5. I would like next column to count the
frequency of each set and return a subtotal in reverse order as shown below.
Any ideas? Maybe I could figure another way to reverse the numbers if I could
just find a way to run the subtotals and start over each time the number in
the first column changes.

1 -5
1 -4
1 -3
1 -2
1 -1
1 0
2 -1
2 0
3 -2
3 -1
3 0
 
Did you mean to post this to an Excel newsgroup?
- This is a FrontPage newsgroup

--




|I have column sorted numbers 1...5. I would like next column to count the
| frequency of each set and return a subtotal in reverse order as shown below.
| Any ideas? Maybe I could figure another way to reverse the numbers if I could
| just find a way to run the subtotals and start over each time the number in
| the first column changes.
|
| 1 -5
| 1 -4
| 1 -3
| 1 -2
| 1 -1
| 1 0
| 2 -1
| 2 0
| 3 -2
| 3 -1
| 3 0
|
|
|
| --
| Rhonda
 
don't do this in cell a1...
suppose you have 1...5 starting from a2:a20
type in b2:
=IF(A2<>A1,-(COUNTIF($A$2:$A$20,A2)-1),B1+1)
next is just copy and paste
 
Back
Top