Hello, I got a very confusing problem. Attached please find the sample sheet.
what I want to get is the 2nd large value from column E to Y based on discount amount in column A.
However, the first function in cell B2 works, but the second one in B4 does NOT. #NUM error. Why?
My excel is 2010 and 2013, both did not work.
error message.JPG
I spent hours trying to fix but no clue totally. Appreciate anyone can help. Tkx.
Bookmarks