row count

[upcea]

I am wondering if there is a way to count the number of rows I have with specific data.

For example:
A
A
A
A (next column it would read "4")
B
B (next column would read "2")
123
123
123
123
123
123 (next column would read "6")

etc. is there a way?

 

[pagrender]

Assuming your data is sorted, is in column A and starts in A1, try this formula in B2 and copy down:
=IF(A2<>A3,COUNTIF($A$1:A2,A2),"")

 

[jeffreybrown]

Maybe not exactly what you are looking for, but how about...

=COUNTIF($A$1:A1,A1) in B1 and drag down

 

[CWatts]

A variation of one already mentioned:

=IF(A2<>A1,COUNTIF($A$1:A1,A1),"")

 

[p45cal]

As long as the values in are grouped and there aren't any say, As outside the group of As, then the results should be right. Copy the formula inB23 down and it's important that the $ symbols are as they are:

Excel Workbook
	A	B
23	A
24	a
25	A
26	A	4
27	B
28	B	2
29	123
30	123
31	123
32	123
33	123
34	123	6
Sheet

 

[upcea]

these aren't working

what if i wanted this:


COLUMN A COLUMN B
A 4
A 4
A 4
A 4
B 2
B 2
123 6
123 6
123 6
123 6
123 6
123 6

 

[pagrender]

Give this a try in B1 and drag down:

=COUNTIF($A:$A,A1)

Your data does not need to be sorted for this to work.

 

[upcea]

my excel has frozen up. excellent. thanks for all of the help! I'll try again in a bit.

 

[pagrender]

I hope I didn't do that to your Excel. This formula, =COUNTIF($A:$A,A1), looks at ALL of column A. You might want to change the range so the calculation is quicker.

An example would be this (change the 100 to meet your needs): =COUNTIF($A$1:$A$100,A1)

 

[upcea]

Not to worry. I will try that tomorrow. It's a huge file so I've had other problems with it.

THanks for your help!