Find largest number in string containing multiple numbers

Originally Posted by Snowtoad

Thanks for the efforts guys, but I just meant nth number chronologically, (not ascending or descending but simply listed from left to right)!
Cheers

HAH! That's funny...
Here you go:
With
A1: 35.328, 32.086, 33.326, 34.479, 34.268, 33.953, 32.497, 31.37, 30.963, 29.252, 29.152, 28.655
B1: the n-th value to find...3

This regular formula returns that value:

C1: =IFERROR(--TRIM(MID(SUBSTITUTE(","&$A$1,",",REPT(" ",LEN($A$1))),LEN(A$1)*B1,LEN(A$1))),"n/a")

In that example, the formula returns: 33.326 (the 3rd value)

Does that help?