Results 1 to 4 of 4

Extract multiple matches into separate rows, but with tables

Threaded View

  1. #1
    Registered User
    Join Date
    03-27-2020
    Location
    nederland
    MS-Off Ver
    2016
    Posts
    16

    Extract multiple matches into separate rows, but with tables

    Hi guys,

    I almost have the INDEX SMALL formula correct, but I am missing one thing.. Hope someone sees it.



    So the formula is from this page: https://exceljet.net/formula/extract...-separate-rows
    {=IFERROR(INDEX(names,SMALL(IF(groups=E$4,ROW(names)-MIN(ROW(names))+1),ROWS($E$5:E5))),"")}





    I want the list in a range (Starting in cell F11) and I get my value from a table, and my IF condition is from a table.



    My formula is:
    {=IFERROR(INDEX(reservering[Positie];SMALL(IF(reservering[status]="uploaden";ROW(reservering[Positie])-ROW(reservering[Positie])+1);ROWS($F$11:F11)));"")}


    reservering[Positie] contains value I need
    reservering status="uploaded" is my condition

    Then comes the part where I screwed it up..

    ROW(reservering[Positie])-ROW(reservering[Positie])+1);ROWS($F$11:F11)))




    I should get 3 values back (because 3 have the "uploaden" condition. I do get 3 results back, but they are all from the same row.


    Obviously, I messed up, can anyone see how I fix it?
    Attached Files Attached Files
    Last edited by MCdyna; 11-16-2021 at 07:01 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Extract data to multiple rows based on value in separate cell
    By jehster1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-24-2018, 02:41 AM
  2. Extract multiple matches into separate columns
    By UBulgan in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-16-2018, 11:33 PM
  3. [SOLVED] Extract & Categorize from Master Tables Into Multiple Tables
    By mycon73 in forum Excel General
    Replies: 8
    Last Post: 05-14-2018, 01:13 PM
  4. [SOLVED] Extract data from tables and populate a separate table?
    By Mirisage in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 01-20-2017, 03:08 PM
  5. Getting rows from a separate sheet that matches a condition
    By sleepy777 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-11-2014, 11:41 PM
  6. Delete rows in separate tabs if string in column A matches
    By bonsaitrees in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 11-14-2012, 03:43 PM
  7. Finding EXACT matches within separate rows
    By IowaTracy in forum Excel General
    Replies: 7
    Last Post: 09-01-2006, 09:11 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