Sort by criteria: number of results

p0k · #1 08-31-2009, 08:45 AM

Hello all,

First please excuse my poor English

I have a file gathering my clients, and I sort them by country, age, gender, etc.
What I'd like to do is selecting a criteria (country for instance) via the scrolling menu and have the number of clients matching this criteria.

How could I do this? Is there a formula or an predefined function for that?

Thanks in advance!

p0k

PKTEE · #2 10-22-2009, 08:33 PM

Use Autofilter for your selection ie Country.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Sort By Last Name in a List	eliz.bell	Word	8	05-07-2009 01:33 PM
filesaveas method for ms project in c# results in error	mikimik	Project	0	10-12-2006 07:53 AM
How to count cells containing data and meet certain criteria	AdamNT	Excel	1	08-11-2006 11:51 PM
Multiple criteria in SUMIF?	pumpkin head	Excel	1	02-17-2006 09:06 AM
Filtering past or future events in DRW query criteria	jvieille	Misc	1	02-11-2006 06:26 AM