Re: automatic sorting

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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.aspx/ms-excel/200809/1

.

Relevant Pages

  • Re: using DSUM in formulae instead of SUMIF
    ... I have a spreadsheet that I enter the pertinent customer contact data into ... Is it possible to somehow sort as the above example illustrates, ... Will the SUMIF function accept IF types of arguments ... > If the pivot table source data will change size frequently, ...
    (microsoft.public.excel.worksheet.functions)
  • Sorting based on one column
    ... I'm trying to sort a spreadsheet based on one cloumns' info. Basically it's ... a ranking of sales for the month with names in the rows. ... Instead of ranking the spreadsheet by column G, ...
    (microsoft.public.excel.misc)
  • Re: Sorting columns in a Transform/crosstab query
    ... Hash: SHA1 ... I really don't recommend changing the table structure just to get a ... sort the column headers by project name within a project type. ... You can't sort the PIVOT values and it doesn't matter if the source is ...
    (microsoft.public.access.queries)
  • Re: Sorting columns in a Transform/crosstab query
    ... Hash: SHA1 ... sort the column headers by project name within a project type. ... You can't sort the PIVOT values and it doesn't matter if the source is ...
    (microsoft.public.access.queries)
  • Re: In which cases/problems is Prolog faster than Java?
    ... Carl Hoare's 1960's quick sort is starting to wear thin in the year 2008 ... So what about parallel implementations of qsort for Prolog? ... partition(Rest, Pivot, Smaller0, Bigger0), ... qsort(Bigger0, Acc, Bigger, Threads2) ...
    (comp.lang.prolog)