Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Top Ten Lists with a twist (or three).
I don't ever seem to ask the obvious. I have a table made up in part of the
following: Col A - Area (there are 8 areas so I am trying to get a top ten for each area) Col C - Names (this is what I want returned) Col H - Points (a person may have multiple lines so I want to total their points and base the rank on the total). Col G - Date (there is a date when the points were scored so I want to total the points for the month selected) And I want the top ten for each area to appear on a different page from the data! (I am not asking for much, I know) SO on tab2 I have a Spinner selecting the Area, and a Spinner selecting the month. SO I want to return the top ten scorers for the selected month. Thank you for even taking the time to read down this far! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If but with a twist:( | New Users to Excel | |||
Sum with a twist | Excel Discussion (Misc queries) | |||
Merging 2 lists with a twist | Excel Worksheet Functions | |||
SaveCopyAs with a twist | Excel Discussion (Misc queries) | |||
Cut / Paste with a Twist | Excel Discussion (Misc queries) |