Results 1 to 3 of 3

copying values from one column with index and match

Threaded View

  1. #1
    Registered User
    Join Date
    10-07-2014
    Location
    Canada
    MS-Off Ver
    2011
    Posts
    3

    copying values from one column with index and match

    So as you can see on the picture, I have a pivot table with values in different columns. What I have to do is make another ordinary table in which I will pull the data from the pivot table. I have to have columns with date and hour and "suma de volume" and "sum of incomes" - which I will then fill with the data from the pivot table. my problem is that for instance on the 8th of January, I have values only from 14 hours, and I have to fill colums in the new table so that 8th of January has 24 hours, and the first 13 hours have the value of zero. Is there a combination of functions that can do that? i tried with iferror index and match but I had no luck. And another problem occurs that for instance the 10th of January has only one value for 1 am, and I have to fill in the rest of the day with 0 values. And I do not have the original data from which the pivot table has been made, just the pivot table.

    Thank you in advance!
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] return multiple values in 1 column via index / match
    By Bax in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-12-2013, 06:54 AM
  2. How do i find the max of two values from index match max of a column
    By mohaymin in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-09-2013, 02:04 PM
  3. Index match offset to get subsequent index values in a column
    By Andrew_Step in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2013, 02:55 PM
  4. [SOLVED] Index/Match/(or other)? Multiple Column/Row Values
    By Pooger in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-22-2013, 09:27 PM
  5. Matching column values in 2 sheets and copying another column over if match
    By cuberis in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-20-2012, 06:55 PM

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