+ Reply to Thread
Results 1 to 3 of 3

Have data automatically build new list based on criteria from a specific column

  1. #1
    Registered User
    Join Date
    03-18-2019
    Location
    Iowa, United States
    MS-Off Ver
    2007
    Posts
    5

    Have data automatically build new list based on criteria from a specific column

    I am building a budget calendar where I have a data sheet as worksheet 1, followed by 12 months worksheets. I am wanting to have each months expenses build the expenses from the data sheet 1 into one column based on the criteria that there is an expense associated with that month, and then return the amount in the next column. This will be used to confirm I have added the items somewhere on each months budget. I've been trying different index-match formulas but keep getting errors.

    I have attached a sample of what I am working on. [budget example.xlsx]

    Your help would be appreciated.
    Attached Files Attached Files

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,213

    Re: Have data automatically build new list based on criteria from a specific column

    Please try at
    B6
    =IFERROR(INDEX(Data!A:A,SMALL(IF(INDEX(Data!$D$3:$O$99,,MATCH($A$4,Data!$D$2:$O$2,))>0,ROW(Data!$A$3:$A$99)),ROWS(B$6:B6))),"")
    Press Ctrl+Shift+Enter

    C6
    =IF(B6="","",SUMIFS(INDEX(Data!$D$3:$O$99,,MATCH($A$4,Data!$D$2:$O$2,)),Data!$A$3:$A$99,B6))
    Attached Files Attached Files

  3. #3
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    office 365 for MAC
    Posts
    3,105

    Re: Have data automatically build new list based on criteria from a specific column

    Different way to get same results, with the indirect formula:

    B6:

    Please Login or Register  to view this content.
    C6:
    Please Login or Register  to view this content.
    Attached Files Attached Files

+ 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. Automatically copying data into a new table based on 2 column criteria
    By gtdread in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-28-2014, 12:25 PM
  2. [SOLVED] VBA - Copy and Paste data based on two criteria to specific start row and column
    By ndgo10 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-02-2014, 09:15 AM
  3. Really easy task - automatically entering data based upon matches in a specific column
    By isthisthewaywego in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-13-2013, 09:00 AM
  4. Move data to specific worksheet based on Column A criteria.
    By forestminuet in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-07-2013, 01:44 PM
  5. Extracting data from column based on specific criteria and pasting into new column
    By vanvalkenburg in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-14-2012, 10:26 PM
  6. Replies: 2
    Last Post: 03-30-2011, 08:05 PM
  7. Build List based on a cell value, with row data from another sheet
    By jhammond10 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-04-2008, 09:17 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