#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 18
Default Formula Question

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
formula question Robert F Excel Discussion (Misc queries) 2 January 26th 07 07:48 PM
Formula Question DonnaS Excel Discussion (Misc queries) 4 November 10th 06 01:47 AM
Newbie Question - Subtraction Formula Question [email protected] Excel Discussion (Misc queries) 3 May 5th 06 05:50 PM
question regarding the IF formula Nelly Excel Discussion (Misc queries) 2 November 8th 05 11:49 PM
Formula question Craig Fletcher Excel Worksheet Functions 2 June 24th 05 03:58 PM


All times are GMT +1. The time now is 09:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"