Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a report where I am weighting results for several locations always
listing a rolling three months, and an average for those three months In column A is Ranking the locations by highest to lowest results In column B are the locations In column C is Jan, D is Feb, E is March, F is Q1 In columns I - L are call volumes for the above months. Columns M - P takes the results for each month and * by the call volume in I - L. I then take certain groups of locations and divide their weighting in columns M - P by their call volume in I - L. For example: Locations in row 2,3,4,8,12 need to be combined. It is random rows every month depending on the result for that month. This is a time consuming effort as I'm manually enter each results with the corrisponding location. What I would like to do is see if there is a formula to look for the locations and the results in the correct columns and divide them to create the weighted result. I want to say this is probably a VLookUp formula but I'm not too familiar with it and can't seem to figure out how to put the division in there or even if it's possible. Hope this makes sense. Any help is appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
formula question | Excel Discussion (Misc queries) | |||
Formula Question | Excel Discussion (Misc queries) | |||
Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
question regarding the IF formula | Excel Discussion (Misc queries) | |||
Formula question | Excel Worksheet Functions |