+ Reply to Thread
Results 1 to 3 of 3

Using keywords for filtering like hashtags

  1. #1
    Forum Contributor
    Join Date
    05-05-2020
    Location
    Germany
    MS-Off Ver
    2013
    Posts
    100

    Question Using keywords for filtering like hashtags

    Hi,

    I creating a list of names and each name (row) has at least 3 keywords as in the table below.
    #
    Name XXX Kewords
    A AA C, D, E
    B BB C, F, G

    now I would like to write a function that allows each user to search a maximum of 2 keywords and see which names have those keywords.
    example:
    let's say the user wants to search keyword C, the answer would be: names A and B. Then the user searches keyword E and the answer would be: name A.

    I would appreciate it if anyone would help me with this.
    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,211

    Re: Using keywords for filtering like hashtags

    Please try at
    G9:G15
    =IFERROR(INDEX($B$8:$B$12;AGGREGATE(15;6;ROW($B$8:$B$12)/ISNUMBER(SEARCH(", "&$F$9&",";", "&$D$8:$D$12&","));ROWS(G$9:G9))-ROW($B$7));"")

    J9:J15
    =IFERROR(INDEX($B$8:$B$12;AGGREGATE(15;6;ROW($B$8:$B$12)/ISNUMBER(SEARCH(", "&$I$9&",";", "&$D$8:$D$12&",")/ISNUMBER(MATCH($B$8:$B$12;$G$9:$G$15;)));ROWS(J$9:J9))-ROW($B$7));"")
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    05-05-2020
    Location
    Germany
    MS-Off Ver
    2013
    Posts
    100

    Re: Using keywords for filtering like hashtags

    Thanks.
    Last edited by (T_T); 08-29-2020 at 04:00 PM.

+ 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] Formula resulting to hashtags (#########################)
    By rcahayag1925 in forum Excel General
    Replies: 4
    Last Post: 05-16-2020, 12:15 AM
  2. Filtering large columns of text based on keywords
    By yogdog in forum Excel General
    Replies: 1
    Last Post: 03-31-2019, 10:08 AM
  3. [SOLVED] Insertion of Random Hashtags in each row of a column
    By WhatsGig in forum Excel General
    Replies: 4
    Last Post: 08-16-2017, 09:09 AM
  4. Arrows and Hashtags Appear When Printing
    By UCP in forum Excel General
    Replies: 6
    Last Post: 10-21-2013, 11:10 AM
  5. [SOLVED] HDI - Return multiple keywords in a text column based on a set of available keywords
    By zneiley in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-25-2013, 01:32 PM
  6. Pivot table and filtering keywords
    By Wayne.wrafter in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 09-11-2013, 05:03 PM
  7. Filtering by list of keywords and pasting results into spreadsheet
    By ej463 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 08-26-2009, 08:10 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