Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula, code or macro?
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula, code or macro?
Correction
Desired output: Mgr % "Tammy" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula, code or macro?
I don't get it all.
You show the Mgr column, yet say it doesn't exist. You want the manager percentage. There are many ways, but you have the rules, what are they? SUM all of Laz, or what? -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Tammy" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula, code or macro?
I need the formula to populate a column with the appropriate mgr. But in my
spreadsheet I don't have a column yet set up designated for mgr. I want it to return an Average % of everything 0 where the mgr = LAZ tamm "Bob Phillips" wrote: I don't get it all. You show the Mgr column, yet say it doesn't exist. You want the manager percentage. There are many ways, but you have the rules, what are they? SUM all of Laz, or what? -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Tammy" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula, code or macro?
Bob - any ideas please?
"Bob Phillips" wrote: I don't get it all. You show the Mgr column, yet say it doesn't exist. You want the manager percentage. There are many ways, but you have the rules, what are they? SUM all of Laz, or what? -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Tammy" wrote in message ... 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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula, code or macro?
Not sure I get it all yet, but if I take a shot, you can tell me what you
expected and why it is different, =AVERAGE(IF((B2:B20="Laz")*(C2:C200),C2:C20)) which is an array formula, so commit it with Ctrl-Shift-Enter, not just Enter. Try this and see if we are close. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Tammy" wrote in message ... Bob - any ideas please? "Bob Phillips" wrote: I don't get it all. You show the Mgr column, yet say it doesn't exist. You want the manager percentage. There are many ways, but you have the rules, what are they? SUM all of Laz, or what? -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Tammy" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Help (Uppercase multiple ranges?) | Excel Discussion (Misc queries) | |||
macro | Excel Discussion (Misc queries) | |||
Help With Macro Code?? | Excel Worksheet Functions | |||
Can someone help me put psuedo code into actual excel macro?? | Excel Discussion (Misc queries) | |||
Help with macro formula and variable | Excel Worksheet Functions |