Working with <## data

[Xipha]

Hi, I have found lots of useful info on this forum before, and I am not a new excel user (I am self taught), but one problem keeps stumping me. I work with a lot of data that contains the < sign. The lab gives us a sheet that has the data, but if is not detected it is entered as <0.05 for example. I have come up with long, tedious ways to work around this in my formulas, but if I want to look up the minimum value (which in some cases may be <0.05) how do I look up in a range and include those numbers beginnning with <? The IF function seems to have trouble with conditions on a range of cells, and I am still learning the numerous other functions at my disposal, so there may be one I have yet to discover that will solve my problem.

E.G.

Data: 23, 45, 62, <0.05, 5, 34, <0.10, 12, Not Analyzed, 14, <0.05
Now I want to look up what the minimum value is (for this data set it should return <0.05). I may have up to 50 similar data sets in my sheet that I would be using the autofill to copy the function from the first data set into. Maybe there is no elegant solution, but I figured maybe someone here knows something I don't! And my life would be a whole ton easier!