C
casdaq
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.
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.