Hello
I have three numbers that are returned by:
=NOW()
=D2
=XLOOKUP(TRUE,criterion1*criterion2,return_range,0)
How can I write a formula that will find the MIN of the above after excluding zeros?
Preferably without helper column or hardcoded values.
Thanks!
I have three numbers that are returned by:
=NOW()
=D2
=XLOOKUP(TRUE,criterion1*criterion2,return_range,0)
How can I write a formula that will find the MIN of the above after excluding zeros?
Preferably without helper column or hardcoded values.
Thanks!