Hi there - me again:

I have a list of approximately 300 airport codes. Those 300 airport codes
are assigned to 5 managers.

I need a query or code or macro or something to help me do the following and
I need it to pick up the % in column F.

On my current spreadsheet, the airport codes are in column A, the manager
column does not exist and the % is column F.


Example of problem:
airport mgr %
DFW Laz 98
AUS Bob 55
SAT Lynn 99
OMH Laz 25
DEN Laz 28
PHI Bob 90

I need to have the Average % by Manager after I have some kind of script
that assisgns the airports to each manager.

Desired output:
Airport Mgr %

Any help appreciated.
Thanks in advance.
Tammy