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