+ Reply to Thread
Results 1 to 2 of 2

Trying to set up a workbook to find average prices paid over several years.

  1. #1
    Registered User
    Join Date
    06-18-2015
    Location
    Iowa, US
    MS-Off Ver
    Office 2007
    Posts
    2

    Trying to set up a workbook to find average prices paid over several years.

    As the title states, I'm working on a workbook to find the average price paid for goods and services over a multi year period.

    I've currently got it set up as follows: Page 1 is the compilation page. I have 3 columns (Item, Unit size, and Avg. Price) where I've alphabetized the items. This list will be changed as needed which means resorting to alphabetize each time an item is added or deleted.

    Page 2 is the template I'll use for the years being looked at, most likely the past 3-5. I have the first two columns on this page set to read from the first two columns on the first page (Item and Unit). Columns 3 and beyond are the sellers columns where I list their names at the top and prices below, matching the prices with the item list on the left.

    Here is where I'm running into 2 major problems. First, when I add an item into the list on the first page and re-alphabetize, the first two columns on the second page work as designed but the rows of the columns that follow (sellers columns) don't shuffle to stay matched to the updated list.
    Second, I want to have the average price on the first page be created by having the software look in each row on the following pages and find the highest price, lowest price, and the median price for each item. My goal is to have a formula that uses (highest+lowest+(median x4)) divided by 6.
    Help with either of these issues would be much appreciated. If you think there's an easier way to do this, let me know!

  2. #2
    Registered User
    Join Date
    06-18-2015
    Location
    Iowa, US
    MS-Off Ver
    Office 2007
    Posts
    2

    Re: Trying to set up a workbook to find average prices paid over several years.

    I'll try to attach the file with some examples.

    AVERAGE PRICES EXAMPLE.xlsx
    Last edited by Amesbear; 06-18-2015 at 02:11 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Average on Prices from DDE
    By stavros21 in forum Excel General
    Replies: 5
    Last Post: 02-03-2015, 01:09 AM
  2. Need to find the average weight for a particular month over many years
    By Miller217 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-01-2014, 12:46 PM
  3. [SOLVED] Average prices etc
    By Bandini in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-12-2014, 10:10 PM
  4. Prices average
    By tofimoon4 in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 11-14-2011, 02:51 AM
  5. Average prices for products throughout time
    By josepablocam in forum Excel General
    Replies: 4
    Last Post: 07-26-2010, 07:57 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1