+ Reply to Thread
Results 1 to 4 of 4

Pick filtered values from checked items

  1. #1
    Registered User
    Join Date
    08-06-2019
    Location
    London
    MS-Off Ver
    2007
    Posts
    2

    Pick filtered values from checked items

    Hi all,

    I have been working on this logic and I know it's very much doable using FILTER and INDEX commands but I am unable to get a smart logic. Please check my screen shot below.

    Clipboard01.jpg

    I am looking to extract values of checked items, as per the numbers assigned to each and put those in another cell. [Red box is the solution I am looking for].

    Any help will be appreciated. Thanks in advance.

    Cheers,
    XL Programmer

  2. #2
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,737

    Re: Pick filtered values from checked items

    In 2007 you can't use TEXTJOIN so in attached file I've included UDF called textjoinSUB and you can use it like below:

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    The rest of 'engine' check in attachment.

    A
    B
    C
    D
    E
    F
    G
    1
    TRUE
    A
    1
    1
    A
    2
    TRUE
    B
    2
    2
    B,D
    3
    C
    2
    3
    F
    4
    TRUE
    D
    2
    4
    G,H,I


    A
    B
    C
    D
    E
    F
    G
    1
    TRUE
    A
    1
    1
    =textjoinSUB(IF(($C$1:$C$20=F1)*($A$1:$A$20=TRUE),$B$1:$B$20,""),",",1)
    2
    TRUE
    B
    2
    2
    =textjoinSUB(IF(($C$1:$C$20=F2)*($A$1:$A$20=TRUE),$B$1:$B$20,""),",",1)
    Sheet: Sheet1
    Attached Files Attached Files
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.

  3. #3
    Registered User
    Join Date
    08-06-2019
    Location
    London
    MS-Off Ver
    2007
    Posts
    2

    Re: Pick filtered values from checked items

    Thanks, You are STAR!

  4. #4
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,737

    Re: Pick filtered values from checked items

    Happy to help.
    Thanks for rep.

+ 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. [SOLVED] Filter Data Based on Unique Column Items and Save the Workbook with Filtered Items
    By IonutC in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-18-2019, 03:08 AM
  2. Replies: 2
    Last Post: 10-03-2018, 02:54 AM
  3. Print Checked Items to Formatted Document
    By Mr_Ekid in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-05-2013, 05:27 PM
  4. Returning the values of filtered items on another sheet
    By tangcla in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 11-11-2013, 10:46 PM
  5. [SOLVED] Make a list from Items not checked off
    By lukereed18 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-08-2013, 02:55 PM
  6. Calculate Maximum Items Checked out
    By jeffwest1230 in forum Excel General
    Replies: 3
    Last Post: 03-05-2010, 06:21 PM
  7. Making a list of checked items
    By aburnce in forum Excel General
    Replies: 1
    Last Post: 12-27-2008, 07:29 PM

Tags for this Thread

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