Worksheet data sorted on another worksheet

[WMB]

All,

Can't seem to get this going. Have some data on 1 worksheet, named cgg, 25
columns, 25 rows.

Would like to have this same data but sorted on column 3 on another
worksheet called cggsorted.

Any idea how best to achieve this, thanks,

Martin

 

[Bernie Deitrick]

Martin,

Enter a new column A on sheet gcc, and in that coulmn, enter RANK functions to rank the value in
column 3, to match the size of your table:

=RANK(C1,$C$1:$C$25,TRUE)
or
=RANK(C1,$C$1:$C$25,FALSE)

(TRUE or FALSE depends on how you want the data sorted, ascending or descending). You also need to
decide how to handle ties....

Anyway, assuming you have no ties, on sheet cggsorted, enter this formula in cell A1

=VLOOKUP(ROW(), cgg!$A$1:$Z$25, COLUMN()+1,FALSE)

and copy to cggsorted A1:Y25

HTH,
Bernie
MS Excel MVP