I am tracking work order production so I have dates in column A and values in column B. I am trying to search for the minimum value in column B and return the date directly to the left of that minimum value. I searched and tried INDEX MATCH and OFFSET but they are not working.
Any ideas?
Any ideas?