My formula is below but I need it to ignore #N/A so it can work-
=MIN(Q2:U2,G2)
Appreciate the help!
My formula is below but I need it to ignore #N/A so it can work-
=MIN(Q2:U2,G2)
Appreciate the help!
How is #N/A generated?
If it is from some calculation. I'd recommend nesting the formula in IFERROR.
Ex:=IFERROR(your formula,"")
If it's from copy/paste or is string/query then...
=AGGREGATE(5,6,Q2:U2,G2)
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
It would really help if we'd know what data you have in Q2:U2 and in G2.
Maybe add a small excel sheet with your data in those cells?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks