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.
You tried converting each of the COUNTIF to COUNTIFS and include the extra criterion?
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
NBVC, the countifs versus countif got me real close, but still could not break the code. We went another direction. thanks for the consideration. Regards, Gary
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks