Outputting specific criteria from a cell - Maximum/Minimum value within CELL

**brad999** · 10-04-2013, 03:25 AM

Afternoon,

I have data which could be in formats such as the following:

0.361 x 3.8
Test: 8.90x0.20=0.487
0.362 * 1.4
~0.85 (0.32*2.45)
0.362 * 1.4=0.67

It could have other similar variants. Basically, in one cell I need to output the SMALLER 0."" number. (Or if there's only one 0."", than that number). So answers from the aforementioned data would be:

0.361
0.20
0.362
0.32
0.362

In another cell, I need to output the n."" number where n is the number above 0. So would need the following answers from the data:

3.8
8.90
1.4
2.45
1.4

I've tried to use functions such as ISNUMBER(SEARCH("n.*" if n>0 or something similar but can't get my head round how to make it this specific! Any help would be greatly appreciated.

Thanks in advance.

**ragulduy** · 10-04-2013, 09:51 AM

Not sure how to do it with functions but this user defined function should return what you want:

Please Login or Register  to view this content.

**brad999** · 10-04-2013, 10:45 AM

Wow looks like some detailed coding! But apologies, I should have mentioned before, but I require it in functions as it will be used on other PCS/workbooks! But thanks, you helped me understand exactly what I need, finding maximum/minimum value within a cell