Hi. Hoping someone can pleaI am trying to create a formula that will give me the lowest number from a comma separated list that exists in a single cell.
I would also like to know which number in the sequence has the lowest number.
Finally, I would like to find the corresponding value from a second comma separated list.
The values are not necessarily in an ordered sequence.
For example.
A1 contains: 6, 5, 4.3, 3.1, 4, 5
B1 contains 1, 3, 4, 3, 5.6, 9.7
I'm trying to find a formula that will give me the lowest value in A1: ie. 3.1 (as the lowest)
I then need a second formula that will give where in the A1 sequence the lowest occurs: ie. 4 (as the 4th value in the list)
Finally, I would like to get the corresponding value (ie. 4th value) in this example from a second list that exists in B1: ie. 3
Have spent a long time trying to solve this unsuccessfully. I would rather a formula solution than a macro as I will need to do this multiple time and manipulate this further.
Thanks for having a look.
Cheers
JWro
Bookmarks