+ Reply to Thread
Results 1 to 4 of 4

Formula to bring text which includes and exludes certain text

  1. #1
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Formula to bring text which includes and exludes certain text

    Hello:

    Please refer to attached file.
    I have list in column H.
    From this list, i need formula in cell A6 down, which list as shown in column A.
    Note : Include as in cell C2 and exlude as in cell D2 down.

    I have shown i need to accomplish in column A.

    Let me know if you have any questions.
    Thanks.

    Riz
    Attached Files Attached Files

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,603

    Re: Formula to bring text which includes and exludes certain text

    Hello again, Riz - Happy New Year to you.

    You could put this formula in cell J4:

    =IF(ISNUMBER(SEARCH($C$2,H4)),IF(COUNTIF($D$2:$D$4,"*"&SUBSTITUTE(H4,$C$2&" ","")),"-",MAX(J$3:J3)+1),"-")

    then copy it down to the bottom of your list of data (or beyond). Then you can use this formula in cell A6:

    =IFERROR(INDEX(H:H,MATCH(ROWS($1:1),$J:$J,0)),"")

    and copy that down as far as you need to, i.e. until you start to get blanks.

    Hope this helps.

    Pete

  3. #3
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Re: Formula to bring text which includes and exludes certain text

    Hello Pete_UK:

    Happy New Year...
    Complicated formula but it works....
    Thanks a lot

    Riz

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,603

    Re: Formula to bring text which includes and exludes certain text

    Glad to be able to help - thanks for the rep.

    Pete

+ 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. Countifs formula with specific text that includes parenthesizes problem
    By kschmit1 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-15-2018, 02:15 PM
  2. bring text box whit Formula
    By musicbox1970 in forum Excel General
    Replies: 4
    Last Post: 03-27-2017, 07:38 PM
  3. [SOLVED] Date Formatting when Formula Includes Text
    By phelbin in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-12-2015, 03:39 PM
  4. Replies: 3
    Last Post: 12-18-2012, 07:19 PM
  5. SUMIFS formula that includes specific text
    By aurisab in forum Excel General
    Replies: 15
    Last Post: 12-16-2012, 08:20 PM
  6. [SOLVED] Counting Cells that includes exact match and also if a cell includes specific text
    By smclachlan in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-19-2012, 07:42 PM
  7. Replies: 2
    Last Post: 05-15-2012, 10:46 PM

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