Posted to microsoft.public.excel.worksheet.functions

Mike H

external usenet poster

Posts: 11,501

Frequency.... I think

Try:-

=COUNTIF(A$1:A$100,A1)

Drag down,

Mike

"DP7" wrote:

HI I have a list of data in column A. The data is a mix of numbers and text.
I need a way to know how often (the frequency) of each value. I tried the
frequency function without any success. A sample of data is below.
A
108JQ8
1108JQ8
1124CB8
124DK5
124DK6
1184BB6
189JV8
1189JV8
124DK6

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Frequency	Blackhawk.34	Excel Discussion (Misc queries)	4	February 7th 07 06:56 PM
Frequency	[email protected]	Excel Discussion (Misc queries)	2	August 30th 06 07:03 PM
Frequency	Fred Roven	Excel Worksheet Functions	2	May 31st 06 03:06 AM
histograms - frequency and relative frequency?	confusedstudent	Excel Discussion (Misc queries)	2	February 8th 06 08:20 AM
frequency	sara	Excel Discussion (Misc queries)	1	April 5th 05 08:15 PM

All times are GMT +1. The time now is 09:04 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us