Hi All,
Should be simple hopefully.
I have this formula
It returns the date in the cell range C2:BH2 if the cell below in C3:BH3 has "SICK".
Is there an edit to exclude the False and Blank results from an array?
Thanks
Should be simple hopefully.
I have this formula
Excel Formula:
=IF(C3:BH3="SICK",C2:BH2)
It returns the date in the cell range C2:BH2 if the cell below in C3:BH3 has "SICK".
Is there an edit to exclude the False and Blank results from an array?
Thanks