count and display unique values
Here's one easy ways (assuming you have a column heading):
Use a Pivot Table
Set ROW to your_col_heading
Set DATA to Count of your_col_heading
Does that help?
***********
Regards,
Ron
XL2002, WinXP-Pro
"joe" wrote:
I need to count and display unique values
a
a
b
b
b
cc
cc
cc
cc
the is a formula to count the number of unique times a value exists but I
also want to display the values in a column.
Thnaks
|