Quote:
Originally Posted by 14spar15
I’m not sure what is going on here.
|
Keep trying!
In the meantime, I think you'll need to be adding the likes of
to your
include element of the FILTER function.
Where exactly and whether you use multiply or add depends on which results you want to see.
For
Quote:
|
where cell V,Y,L and R have no data
|
you could use
Code:
*((Y26:Y500 & V26:V500 & L26:L500 & R26:R500)<>"")
although if there are errant spaces in those cells the liberal use of TRIM should help.
For
Quote:
|
don’t want any rows selected if all the search cells (G2,J2 and M2) are blank
|
you could wrap the whole formula in
Code:
=IF(G2 & J2 & M2 ="","Empty Criteria",yourFilterFormula)
All in all, quite convoluted.
Edit:
I note in your formula in msg#1 you have:
ISNUMBER(SEARCH (J2,R26:R500))
where there's a space between the H of SEARCH and the open parentheses. I hope it's the website's mangling of your formula because when I pasted the formula into a cell it didn't throw any error but the result was wrong.