Results 1 to 3 of 3

omit specific word in array

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-15-2010
    Location
    Oklahoma
    MS-Off Ver
    Excel 2019
    Posts
    168

    Question omit specific word in array

    I have an array formula that works perfectly in:

    IF(COUNTIF(BV$18:BV$296,">"&J60), INDEX(BV$18:BV$296, MATCH(COUNTIF(BV$18:BV$296,"<="&J60), COUNTIF(BV$18:BV$296,"<"&BV$18:BV$296),0)),""

    I wish to keep the formula intact but include a rule that would not allow the word "sales tax" to be included. Each of my attempts eliminates everything. Is there a means of adding to this formula to stop the word "sales tax"? Thank you for your consideration. Regards, Gary
    Last edited by allgeef; 03-18-2011 at 11:38 PM.

Thread Information

Users Browsing this Thread

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

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