Results 1 to 7 of 7

Array Formula — Filtered List— Problem

Threaded View

  1. #1
    Registered User
    Join Date
    09-19-2016
    Location
    Angeles, Pampanga, Philippines
    MS-Off Ver
    2016
    Posts
    4

    Array Formula — Filtered List— Problem

    Hello.

    I need some help with an array formula

    The formula filters out a list from another array.

    I would use 1's as a filter (check the attachment sheet1 for reference) and that usually works fine.
    Like this:

    item A - 1
    item B - 0
    item C - 1
    item D - 1
    item E - 0

    Filtered List:
    item A
    item C
    item D

    But I would have problems when other numbers are there. Like this:
    item A - 1
    item B - 2
    item C - 0
    item D - 0
    item E - 1

    I would like the result to be like this:
    item A
    item B
    item B
    item E

    Is there an array formula that would instead count the instances of the number and then filter out a list from it.
    Thanks

    See attachment for reference on what formula I already have and the result of what I want.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA Code Problem when Using a Filtered List
    By HangMan in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-13-2015, 12:02 PM
  2. Creating filtered array within formula before then calculating percentil
    By bpomeroy in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-05-2014, 09:52 AM
  3. Array formula to create list of filtered results
    By Kris_cs1 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-16-2014, 02:34 AM
  4. [SOLVED] Count number of unique names in a filtered list (non array)
    By IN_FOR_SIN in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 01-31-2014, 04:07 AM
  5. Slightly Different Filtered Validation List Problem
    By alrCompass in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-12-2012, 05:40 AM
  6. Filtered list into an array
    By Macro1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-08-2011, 06:17 AM
  7. Filtered list & maximum no columns problem
    By claytorm in forum Excel General
    Replies: 0
    Last Post: 08-24-2005, 05:52 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