#1
|
|||
|
|||
Sort by criteria: number of results
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 |
#2
|
|||
|
|||
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 |