Results 1 to 9 of 9

Pulling data from list into month/year table

Threaded View

  1. #1
    Registered User
    Join Date
    09-13-2013
    Location
    California
    MS-Off Ver
    Excel 2013
    Posts
    5

    Pulling data from list into month/year table

    Hey Guys,

    I am trying to create a table (years on top, months on side) to track my utility meter data. I have a lot of data with random start and end dates and i've been trying to get the data ("Average daily consumption normalized for calender" column) to simply go into the cell that applies to it (example: if I had a meter start date of august 10th 2007, I would want that to pull from the list into the table cell for august 2007.) The main problem I'm having is getting it to recognize the years and format it correctly. At first this seemed an easy task, but I've given it a few days work, tried many things, and not much has proven successful. Below are a few images of what i'm looking at and trying to accomplish. One is of the list I'm trying to pull from, and the other is the table i'm trying to put the data into. I would appreciate any help or advice. Thank you. expirement table 1.jpgexpirement table 2.JPG
    Attached Images Attached Images
    Last edited by EC11; 09-16-2013 at 06:54 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to add Month-on-Month and Year-on-Year %Variance into a pivot table
    By emeritus1812 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 06-09-2013, 02:37 AM
  2. If Column A Month and Year = ColumnB Todays Month and Year then send email
    By HACCStaff in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-15-2013, 12:47 AM
  3. [SOLVED] Sort by Month and year in pivot table
    By mb1074 in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 01-21-2013, 02:05 PM
  4. [SOLVED] how to return a day(number) by selecting month and year from data list
    By lizsantiago07 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 12-24-2012, 02:43 PM
  5. Pulling of month & year from date cell
    By tariqnaz2005 in forum Excel General
    Replies: 5
    Last Post: 12-02-2009, 10:40 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