Working with <## data

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!

If you want to actually return <0.05, then, assuming data is in A2:A12 try:

=INDEX(A2:A12,MATCH(TRUE,SUBSTITUTE(A2:A12,"<","")+0=MIN(IF(ISNUMBER(SUBSTITUTE(A2:A12,"<","")+0),SUBSTITUTE(A2:A12,"<","")+0)),0))

confirmed with CTRL+SHIFT+ENTER not just ENTER

Perfect! Both solutions worked the way they were supposed to (although I did have to take the fixed references out of the "INDEX" function in order to apply the formula to all the data set ), now I just have to learn what exactly each function does and the how the logic is applied, and I think my life will be a lot easier when I run into similar problems! Thanks for all the help, it's given me a starting place to learn some new stuff

Did you try my formula above? It retains the "<" symbol.