Sort Question
Is there a way to Sort this SOURCE data by highest average and EXCLUDE Team 2
in the sort.
Note that the SOURCE and RESULT data are on the same worksheet.
Here's the SOURCE data:
Column
A B C
Row
15 TEAM PLAYER AVERAGE
16 1 Bob .333
17 1 John .250
18 2 Al .450
19 1 Charlie .500
Here's the RESULT data that I would like:
Column
A B C
Row
1 TEAM PLAYER AVERAGE
2 1 Charlie .500
3 1 Bob .333
4 1 John .250
I know the code for sorting, but can't seem to figure out a way of excluding
the data WITHOUT Deleting it (HIDE ROW doesn't work).
Can anyone help here?
Thanks.
Gary
|