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 Name (from the same row as the blank).
Thanks AL
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.
4 Replies
- This formula also works great, thanks for your time and help!
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!
