Number greater than and string of values

[clanko]

Hello i search a way to find the number of value greater that a variable (ex : 3.5) on a string of number. So i can't organize the value

To better understand : Example : I want to find the value greater than 3.5 on a string. So when the number drop below 3.5, the string close.

I should be getting (if i put Max at the beggining of the function) i should be getting 3 (and not 5).
and if i put minimum, i should get 2.

2

2

4

5

4

3

4

4

3

[José Augusto]

You want the highest value that is no greater than 3.5. That's it?
The string is made up of integer numbers?
If so, the array formula is

=MAX(IF(MID(H3,ROW(INDIRECT("A1:A"&LEN(H3))),1)+0>3.5,0,MID(H3,ROW(INDIRECT("A1:A"&LEN(H3))),1)+0))

where H3 is the string. Ex:H3="224543443" --> 3

[mahju]

Please explain
Your string is in one cell
It is numeric or entered as text
Its length is fixed or can vary
You want number greater than a given number, first or all the numbers

2 2 4 5 4 3 4 4 3

if value is 3.5, answer is 3
if value is 2, what should be the answer

Regards