I have two columns, column A=months, column B=values. Column B has some negative values in it. How do I find the closest value to zero in column B, then figure out which month this value occurs?
I don't want the lowest number -- just the one closest to zero. Would the min function still work here?
Thanks
I don't want the lowest number -- just the one closest to zero. Would the min function still work here?
Thanks