Forum Discussion
Solved
simple formula help: if text does not exist display specific cells from same row
could someone help me with a simple formula to: if text does not exist display specific cells from same row Formula Rule: If amount cell (col F) is blank display: Username: First Name: Last Nam...
In case you are MS365 subscriber, this (in F26) will do there trick:
=FILTER(FILTER(B2:F17,D2:D17="","-"),{1,0,0,1,1})Otherwise consider using a pivot table to achieve a similar result. See example in column M. File attached.
In case you are MS365 subscriber, this (in F26) will do there trick:
=FILTER(FILTER(B2:F17,D2:D17="","-"),{1,0,0,1,1})Otherwise consider using a pivot table to achieve a similar result. See example in column M. File attached.
Thanks for your quick response and formula that works great!
