My data is:
| Numbers |
|---|
| 1 |
| 2.3 |
| 3.2, 4.5 |
| 2.3 |
| 3 |
| 1.1,2.2,3.4 |
What I want to do is get the max value for each row
My current formula is
=MATCH(1000,INDEX(FIND(","&ROW(INDIRECT("1:999"))&",",","&B2&","),0))
However that isn't working on the rows with a decimal point. Any help would be greatly appreciated!!
CodePudding user response：
I’m pretty sure you can use =MAX function, just tested in LibreOffice Calc and it worked with floats as well, should be fine in Excel too
CodePudding user response：
The solution to this is
=MAX(0 MID(SUBSTITUTE(D3, ",", REPT(" ",255)), 255*(ROW(INDIRECT("1:"&(1 LEN(D3)-LEN(SUBSTITUTE(D3,",","")))))-1) 1,255))
Thanks
CodePudding user response：
Assuming the data shown in the OP covers all cases, the following does what you want.
=VALUE(RIGHT(D3,3))
If that doesn't address the question, could you expand your data sample to show examples that fail?