+ Reply to Thread
Results 1 to 2 of 2

Spilled Data With Two Criterias

  1. #1
    Registered User
    Join Date
    08-29-2020
    Location
    Chicago
    MS-Off Ver
    Office 365
    Posts
    7

    Spilled Data With Two Criterias

    Hello Everyone,

    I am working on a data set, for financial analysis, where I have various expense categories and months. In the attached example, I want to input the month and the category I need, then have it spill the data (explanation is in row 59)

    I tried experimenting with Xlookups and the filter formula, but the examples I researched normally have the inputs neatly organized in one row. My two inputs are in both a row (B2-B52) and a column (F1-J1). Is it possible to spill a data set using criteria that is in both a row and a column?


    Thanks in advance.
    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: Spilled Data With Two Criterias

    Please try

    =FILTER(FILTER(C2:J52,B2:B52=B57),ISTEXT(C1:J1)+(C1:J1=B56))

    format Column C as # to hide Zero
    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. Concat spilled data
    By aguanigei in forum Excel General
    Replies: 5
    Last Post: 04-20-2020, 10:48 AM
  2. Countifs / Sumifs with dynamic arrays (spilled ranges)
    By esbencito in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 03-08-2020, 02:43 PM
  3. Dynamic, Spilled, Named Ranges - how to override SPILL
    By TimB in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-24-2020, 01:53 PM
  4. [SOLVED] YTD with dynamic spilled array
    By MatthewHart74 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 12-14-2019, 07:49 AM
  5. YTD with spilled dynamic array
    By MatthewHart74 in forum Office 365
    Replies: 0
    Last Post: 12-12-2019, 12:05 PM
  6. Replies: 6
    Last Post: 02-23-2018, 07:09 PM
  7. [SOLVED] Macro Find set criterias to a colomn of number, delete the rows that don't meet criterias
    By TAMMY32 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-03-2017, 04:09 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