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

Probably the easiest way would be to create a pivot table from your source
data. Select the data you would like to work with and the select data -
pivot table. Follow the wizard. Place the team in the right column and the
players nest to the team. Put the averages in the middle and off you go. With
a pivot table you can choose what teams you want to show or not. You will
have to sort by average by selelecting the team right click and select
advanced. Change the sort option and you should have what you want.
--
HTH...

Jim Thomlinson


"G" wrote:

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

It seems to me that there must be a simpler way to do this ... isn't there a
function similar to HIDE that will also EXCLUDE cell data from a calculation
based on criteria?

"Jim Thomlinson" wrote:

Probably the easiest way would be to create a pivot table from your source
data. Select the data you would like to work with and the select data -
pivot table. Follow the wizard. Place the team in the right column and the
players nest to the team. Put the averages in the middle and off you go. With
a pivot table you can choose what teams you want to show or not. You will
have to sort by average by selelecting the team right click and select
advanced. Change the sort option and you should have what you want.
--
HTH...

Jim Thomlinson


"G" wrote:

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

Just do a two column sort. sort on team for Key 1 and average for key 2


--
Regards,
Tom Ogilvy


"G" wrote in message
...
It seems to me that there must be a simpler way to do this ... isn't there
a
function similar to HIDE that will also EXCLUDE cell data from a
calculation
based on criteria?

"Jim Thomlinson" wrote:

Probably the easiest way would be to create a pivot table from your
source
data. Select the data you would like to work with and the select data -
pivot table. Follow the wizard. Place the team in the right column and
the
players nest to the team. Put the averages in the middle and off you go.
With
a pivot table you can choose what teams you want to show or not. You
will
have to sort by average by selelecting the team right click and select
advanced. Change the sort option and you should have what you want.
--
HTH...

Jim Thomlinson


"G" wrote:

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