+ Reply to Thread
Results 1 to 8 of 8

Search of PT Row label not finding string

  1. #1
    Registered User
    Join Date
    06-05-2011
    Location
    Cornwall
    MS-Off Ver
    Excel 2019
    Posts
    78

    Search of PT Row label not finding string

    I am using the following formulae
    =ISNUMBER(SEARCH(B38,G32))

    Where B38, is the row label "P, M" and G32 is "M" (my added quotes)
    It returns FALSE, plainly not correct. What have I got wrong?

    Thanks
    Peter

  2. #2
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Search of PT Row label not finding string

    It is seems working nicely ... attach a short Excel file sample to illustrate the issue
    - Battle without fear gives no glory - Just try

  3. #3
    Registered User
    Join Date
    06-05-2011
    Location
    Cornwall
    MS-Off Ver
    Excel 2019
    Posts
    78

    Re: Search of PT Row label not finding string

    Thanks for the reply, how about a screenshot.

    PT snip.JPG

    The line F35 to I35 was my first attempt and uses this formulae.
    =IF(ISNUMBER(SEARCH($B$38,F32)),"Yes","No")

    I could not understand why it came back with No and so tried the formulae in my first post in G36
    I expected it to find the Letter in the Row Label and be TRUE

  4. #4
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,446

    Re: Search of PT Row label not finding string

    Administrative note

    Welcome to the forum

    in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ? ( pictures are nice to look at but useless to work with)

    Please take a moment to read it and attach a sheet accordingly.

    Thanks you for helping us help you

  5. #5
    Registered User
    Join Date
    06-05-2011
    Location
    Cornwall
    MS-Off Ver
    Excel 2019
    Posts
    78

    Re: Search of PT Row label not finding string

    Yes ok, I was being lazy by using a picture.
    The PT analyses a 250 x 10 cell Table with confidential information in it. I would have to write a new data set and PT to post it:
    and I don't think the problem is the PT or the data it is based on, it is the text Search I am trying to do.

  6. #6
    Forum Contributor
    Join Date
    11-20-2007
    Location
    Felixstowe, England
    MS-Off Ver
    Excel 2013, 2019
    Posts
    217

    Re: Search of PT Row label not finding string

    Surely you have the arguments reversed ... it should be:
    =ISNUMBER(SEARCH(G32,B38))
    maybe?

  7. #7
    Registered User
    Join Date
    06-05-2011
    Location
    Cornwall
    MS-Off Ver
    Excel 2019
    Posts
    78

    Re: Search of PT Row label not finding string

    doh !! Of course you are right.

  8. #8
    Forum Contributor
    Join Date
    11-20-2007
    Location
    Felixstowe, England
    MS-Off Ver
    Excel 2013, 2019
    Posts
    217

    Re: Search of PT Row label not finding string

    ... glad to help.

+ 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. Replies: 6
    Last Post: 09-05-2019, 07:45 AM
  2. [SOLVED] Need to search cell for text string and paste text in based on finding
    By roland77 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-29-2014, 08:56 PM
  3. [SOLVED] problem finding string using .find method when string to be found contains ~ (a tilde)
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-01-2013, 07:38 AM
  4. [SOLVED] Search for string across header row, then search for another string down found column
    By TucsonJack in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-14-2012, 02:09 PM
  5. Replies: 1
    Last Post: 04-16-2010, 03:50 AM
  6. Finding Label/Symbol of Biggest Value in an Array
    By uberathlete in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-12-2007, 05:51 PM
  7. search a string withing a string : find / search hangs
    By itarnak in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-24-2005, 11:05 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