Counting Data

X

Xavier

Is there a way to make Excel count the data in a particular column? For example

219
333
234
219
555
234

I'd want the output to say this

2192 =
3334 =
2343 =
5553 =
 
J

Jason Morin

Try a Pivot Table (go to Data > Pivot Table).

HTH
Jason
Atlanta, GA
-----Original Message-----
Is there a way to make Excel count the data in a
Click to expand...
particular column? For example:
 
N

Norman Harker

Hi Xavier!

First use the following to extract unique entries:

=IF(COUNTIF($A$1:A1,A1)=1,A1,"")
Entered as an array by pressing and holding down Ctrl + Shift and then
pressing Enter
Now copy down parallel to your data entry

You can now use the formula:
=COUNTIF($A$1:$A$6,D1)
Copy down

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
S

Soo Cheon Jheong

Xavier! Try:

Sheet1:
--------------------------------------------------
A B C D E F G H
1 Data
2 2192
3 3334
4 2343
5 2192
6 5553
7 2343
8 .
9 .
--------------------------------------------------


Module1:
--------------------------------------------------
Sub Summary()

Dim R As Long
R = Cells(Rows.Count, "A").End(xlUp).Row
If R < 2 Then Exit Sub

Range("F:H").ClearContents
Range("A1:A" & R).AdvancedFilter _
Action:=xlFilterCopy, _
CopyToRange:=Range("F1"), _
Unique:=True

R = Cells(Rows.Count, "F").End(xlUp).Row
If R < 2 Then Exit Sub

Range("G2:G" & R).Value = "'="
Range("H2:H" & R).Value = "=COUNTIF($A:$A,F2)"
Range("F:H").EntireColumn.AutoFit

End Sub
--------------------------------------------------


--
Regards,
Soo Cheon Jheong
Seoul, Korea
_ _
^¢¯^
--
 
Top