Posted to microsoft.public.excel.programming

kwh

external usenet poster

Posts: 13

Advanced Filtering by top scores

I am requiring filtering of a list of employees over a who are scored on
performance over a period of time. I would like to filter for the top five
most recent dates for each employee and average the scores for that filtered
data.

Is that possible in advanced filtering? If so, how is it done?

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
Advanced Filtering	Corina	Excel Discussion (Misc queries)	2	March 18th 10 06:28 AM
advanced filtering	Lola	Excel Discussion (Misc queries)	1	February 27th 08 08:16 PM
Advanced filtering	mutie	Excel Worksheet Functions	8	July 2nd 06 03:28 PM
advanced filtering in XLS	Tina	Excel Worksheet Functions	1	September 3rd 05 01:50 PM
Advanced Filtering	Tony	Excel Worksheet Functions	3	April 29th 05 11:48 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us