Posted to microsoft.public.excel.worksheet.functions

Bernd P

external usenet poster

Posts: 806

Unique Counting With Multiple Criteria

Hello again,

If you want a simple report which is "auto-updating", select a
sufficiently long area with 2 columns and array-enter:
=Pfreq(Pfreq(C1:C999,B1:B999))

My UDF Pfreq you will find he
http://www.sulprobil.com/html/pfreq.html

Regards,
Bernd

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
Counting Unique Values with Multiple Criteria	Amber	Excel Worksheet Functions	3	September 25th 07 02:52 PM
Counting Unique Items with Multiple Criteria	Joe Gieder	Excel Worksheet Functions	3	March 5th 07 10:08 PM
Counting Unique Items with Multiple Criteria	Teethless mama	Excel Worksheet Functions	0	March 2nd 07 11:12 PM
Counting Unique Items with Multiple Criteria	Ron Coderre	Excel Worksheet Functions	0	March 2nd 07 10:51 PM
Counting Unique Values Given Criteria	carl	Excel Worksheet Functions	2	August 20th 05 04:22 PM

All times are GMT +1. The time now is 10:40 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us