Hi,
I have a spreadsheet for my workplace to search a range of suppliers to return which supplier has the cheapest price for the one product. I have a range of numbers (dollars) in a range (lets say H2:N2), but there are also dates within that range for the day that the price was quoted. What I am trying to create is a formula to show the smallest (cheapest) and second smallest (second cheapest) prices available. I have been using the SMALL function which works great for the cheapest supplier. However every now and then, there are no second smallest numbers. In other words, I haven't received any other pricing from any other suppliers yet. So the formula returns dates that are within that range. In short, I know how to get the cheapest value. But if the next cheapest value happens to be a date, then return "STC" (still to check)? See example spreadheet (Problem exists in E3).Example.xlsx
Bookmarks