frequencies?

  • Thread starter Thread starter Tom G
  • Start date Start date
T

Tom G

I have a range named SCHOOL. It contains about 14000 entries, but only about
100 values that repeat themselves.

I want to be able to find out which values appear in school (i.e., the
frequencies of each value).

Thanks,
Tom
 
Hi Tom!

See:

Chip Pearson:
http://www.cpearson.com/excel/duplicat.htm#HighlightingDuplicates

There you'll find a conditional formatting formula to highlight the
duplicates. There's also lots more for you on the unique / duplicate
problems.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Hi Tom
if your data is in column A enter the following formula in B1
=COUNTIF($A:$A,A1)
and copy this formula down. All rows with a '1' in it are unique
entries
 
thanks Frank,
This isn't exactly what I need. Say I have column A1:A100 with an unknown
number of repeating values (i.e., some are 1 or 2 or 3 or 4 ... ). I don't
know which values are in A1:A100, I know that many of them are repeated.

I need to know the entire range of unique values in A1:A100, and how many of
each appear.

Thanks,
Tom
 
Hi Tom
one way: use a pivot table :-)
- Insert a header in column A (in cell A1). Lets say you insert 'Data'
- Select column A and goto ' Data - Pivot table'
- follow the wizard and use 'Data' Row element
- use Count of 'Data' ad data element
- finish the wizard

Now you should have a report with all unique entries and the number of
their individula occurences
 
Back
Top