+ Reply to Thread
Results 1 to 18 of 18

I try to generate a list based on a criteria, but ...

Hybrid View

  1. #1
    Registered User
    Join Date
    09-15-2022
    Location
    texas
    MS-Off Ver
    2016
    Posts
    7

    Re: I try to generate a list based on a criteria, but ...

    Many thanks to the all the users who tried to assist me, especially to CARACALLA for his solution. We all have many things still to learn, me included!

  2. #2
    Forum Expert
    Join Date
    09-25-2015
    Location
    Milan Italy
    MS-Off Ver
    office 365
    Posts
    1,986

    Re: I try to generate a list based on a criteria, but ...

    Correct file.
    The previous one had a wrong structure

    G14=SUMPRODUCT((ISNUMBER(MATCH($A$3:$K$10,$F14,0)))*(N(+$B$3:$L$10))*(INDEX($A$3:$K$10,,MATCH($E$13,$A$2:$K$2,0))=$E$14))

    Copy down


    I14=SUMPRODUCT((ISNUMBER(MATCH($A$3:$K$10,$F14,0)))*(N(+$B$3:$L$10))*(INDEX($A$3:$K$10,,MATCH($E$13,$A$2:$K$2,0))=$E$14)*($A$1:$K$1=I$13))

+ 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. Generate a list based of certain criteria from multiple sheets
    By yarmin in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-31-2018, 03:36 AM
  2. [SOLVED] Generate list of dates between dates based on criteria - Onsite/Offshore holidays
    By sreeks in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-21-2017, 12:37 AM
  3. [SOLVED] Generate a list based on meeting certain criteria.
    By Losguapos1 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 11-01-2015, 01:32 PM
  4. Generate a list based on meeting a criteria
    By nekomi15 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-02-2015, 02:31 PM
  5. Excel 2007 : How to generate a list based on criteria
    By fraggle in forum Excel General
    Replies: 7
    Last Post: 05-20-2015, 04:41 AM
  6. Generate list of names based on multiple criteria
    By mattadler22 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-03-2013, 06:02 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