Posted to microsoft.public.excel.misc

tom g

external usenet poster

Posts: 1

simple frequencies

I have to calculate simple frequencies of unique values in a column.

For example

USA
China
France
USA
Norway
UK
China
UK
China

I need to create a list with the frequency of how often each vaule
appears in that list.

i.e.
China 3
France 1
Norway 1
UK 2
USA 2

Thanks!

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
Simple message box question	zeyneddine	Excel Discussion (Misc queries)	4	August 23rd 06 06:08 PM
Simple message box question	zeyneddine	Excel Discussion (Misc queries)	1	August 14th 06 08:23 PM
Simple Calculator Problem	Wheelz	Excel Worksheet Functions	4	August 9th 06 07:41 PM
simple formula	taxmom	Excel Worksheet Functions	3	August 8th 06 09:09 PM
Help with what should be a simple formula	B Millar via OfficeKB.com	Excel Worksheet Functions	2	June 16th 05 04:18 PM

All times are GMT +1. The time now is 03:59 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us