I have a spreadsheet with a lot of data that changes on a monthly basis. To
change the data in the spreadsheet, I simply change the month on the first
page, and retrieve from linked information. I would like to set up a
"rankings" sheet that shows sorted data (in various categories)...but the
order changes each month. Is there any way to set up formulas, etc., to
avoid having to manually sort the data in the rankings sheet each month.
Example:
Scores, respectively, for competitions A,B,C,&D
blue (4,8,2,8)
green (2,3,9,4)
purple (3,0,4,2)
yellow(9,6,2,1)
black(3,1,9,4)

I want to show lists of the teams (colors) in order by their scores for each
competition, but I would like that to be done automatically each month when
the scores change. Any advice?

Hi
Have you tried using Pivot tables to build views. You can sort them by
descending order, and ranking them etc.
I have a similar spreadsheet updated via a link, and have 60 tabs of pivots
Thanks

Matt





Curious wrote:
I have a spreadsheet with a lot of data that changes on a monthly basis. To
change the data in the spreadsheet, I simply change the month on the first
page, and retrieve from linked information. I would like to set up a
"rankings" sheet that shows sorted data (in various categories)...but the
order changes each month. Is there any way to set up formulas, etc., to
avoid having to manually sort the data in the rankings sheet each month.
Example:
Scores, respectively, for competitions A,B,C,&D
blue (4,8,2,8)
green (2,3,9,4)
purple (3,0,4,2)
yellow(9,6,2,1)
black(3,1,9,4)

I want to show lists of the teams (colors) in order by their scores for each
competition, but I would like that to be done automatically each month when
the scores change. Any advice?

--
Matt Lynn

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200809/1