Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with Lookup formula
I have a spreadsheet where I would like to quantify the amount of
entries pertaining the to the following: Column A = Supervisors Names (A, B, C, D, E) Column D = Status (Awaiting Contracts, In Progress, Complete) Column E = Contract Value ($) I would like to create a list that can extract from the above columns the number of jobs each supervisor has at each status and the $ value (expressed as a total) for each status. If anyone can offer assistance on this subject, i would be very thankful. Regards, Alan |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with Lookup formula
This is actually a great reason to use a pivot table.
"barts" wrote: I have a spreadsheet where I would like to quantify the amount of entries pertaining the to the following: Column A = Supervisors Names (A, B, C, D, E) Column D = Status (Awaiting Contracts, In Progress, Complete) Column E = Contract Value ($) I would like to create a list that can extract from the above columns the number of jobs each supervisor has at each status and the $ value (expressed as a total) for each status. If anyone can offer assistance on this subject, i would be very thankful. Regards, Alan |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with Lookup formula
I have just completed a report for someone along similar lines but in much
greater detail. It's hard to explain what i have done but if you could send me something I could write an example in for you. "barts" wrote: I have a spreadsheet where I would like to quantify the amount of entries pertaining the to the following: Column A = Supervisors Names (A, B, C, D, E) Column D = Status (Awaiting Contracts, In Progress, Complete) Column E = Contract Value ($) I would like to create a list that can extract from the above columns the number of jobs each supervisor has at each status and the $ value (expressed as a total) for each status. If anyone can offer assistance on this subject, i would be very thankful. Regards, Alan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LOOKUP formula | Excel Worksheet Functions | |||
lookup formula | Excel Discussion (Misc queries) | |||
lookup formula? | Excel Worksheet Functions | |||
Lookup Formula??? | Excel Worksheet Functions | |||
Lookup Formula - but have a formula if it can't find/match a value | Excel Worksheet Functions |