B
Bigfoot17
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!
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!