Hello,
I have several cells with values or ranges of values:
Example from column A
0,005
0,001-0,002
0,003
0,002
0,006
I would like to find the minimum value
In this case the formula should take the 5 left characters from every cell and give the minimum result.
I was thinking to do this...
... but obviously it doesn't work.Please Login or Register to view this content.
I don't want to make a separate column unless it's necessary.
Thanks for your advice!
Bookmarks