Results 1 to 10 of 10

Partial text match not pulling data using Syntax of FILTER followed by ISNUMBER SEARCH

Threaded View

paradise2sr Partial text match not... 09-02-2022, 02:02 AM
AliGW Re: Partial text match not... 09-02-2022, 02:04 AM
paradise2sr Re: Partial text match not... 09-02-2022, 02:43 AM
AliGW Re: Partial text match not... 09-02-2022, 03:03 AM
paradise2sr Re: Partial text match not... 09-02-2022, 04:05 AM
Glenn Kennedy Re: Partial text match not... 09-02-2022, 04:33 AM
HansDouwe Re: Partial text match not... 09-02-2022, 04:36 AM
paradise2sr Re: Partial text match not... 09-02-2022, 04:41 AM
HansDouwe Re: Partial text match not... 09-02-2022, 06:33 AM
AliGW Re: Partial text match not... 09-02-2022, 06:34 AM
  1. 09-02-2022, 02:02 AM #1
    paradise2sr is offline
    Forum Contributor
    Join Date
    03-11-2011
    Location
    Nepal
    MS-Off Ver
    MS Excel 2024
    Posts
    1,426

    Partial text match not pulling data using Syntax of FILTER followed by ISNUMBER SEARCH

    Hi,

    I have used the below syntax but its not pulling data.

    =FILTER(AC!A5:B9,AC!C5:C9=ISNUMBER(SEARCH(C1,AC!C5:C9)),"Not found")
    What's wrong in this syntax
    Last edited by paradise2sr; 09-02-2022 at 02:42 AM. Reason: it was reference for Private workbook
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Partial match to search number and text
    By chaiyya345 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-17-2022, 03:54 AM
  2. [SOLVED] Index match 2 items returning multiple results & search for partial text
    By billrogers184 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-25-2020, 01:45 PM
  3. ComboBox Filter, search with partial text improvement
    By teun-lll in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-06-2020, 02:38 AM
  4. [SOLVED] Index/Match combining with Search (partial text string)
    By iasinschi in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-29-2018, 05:08 PM
  5. Search and Match partial text string to full text and return a value
    By homa5424 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-09-2017, 10:52 AM
  6. [SOLVED] Function that will search partial text match and place a 1 in column
    By thebrin in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-10-2017, 01:38 AM
  7. Search and copy based on partial text match
    By PIQalap in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-12-2014, 11:36 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1