In the attached file I want to find the lowest (small) value in the column C3:C23. The range does contain some errors so I thought I would try an Aggregate function. I followed the popup suggestions using, 15 to find small, 6 to ignore errors and the range C3:C23 but something is not working.
Any suggestions?
Jim O
Bookmarks