Lowest number in comma separated list from a single cell

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

Here, I've create you UDF that will calculate what you want with delimiter you want.
Use it as:

Formula:

Please Login or Register  to view this content.

Where first word is what you try to calculate (SUM, MAX, MIN, COUNT or AVERAGE)
A1 is range
"," is delimiter. In this case ,

Please Login or Register  to view this content.

Thanks to all the posts. Definitely helping already.

Question 1 - solved. The solutions from A1Key and XOR LX for the first question are awesome.
Question 2 - when finding which number in the sequence, both solutions gets tripped up by finding a matching digit but not necessarily the matching number. ie. If 1 is the lowest number, it finds the first match of 1 which may be part of a larger number (eg. 12).
Question 3- A1Key's solution doesn't work when the minimum value is first in the list - not sure why. Also, can't get XOR LX's solution for question 3 to work at all.

Any further advice available?
Much appreciated,
JWro

Thanks to all that took the time to provide some help for the above query.
My question has now become a little more complex.
sample sheet
A B C
1 1,2,3,4,5 2,3,4,6,7
2 2,4,7 3,4,6
3 8,4,9,12,12,1,5 1,2,3,6,5,4,7

I would like to fill in column C with a corresponding list of products of A and B such that C1 = 2,6,12,24,35 (ie. 1x2, 2x3, 3x4, 4x6, 5x7)

As you can see, not all lists in column A and B have the same length and not all lists are ordered in magnitude.

I suspect I need to use VBA but not really sure where to start.

I would greatly appreciate any guidance.
Thanks.

After further searching, I think I have solved my own post with the following code:

CPET1 = ActiveCell.Value
CPET2 = ActiveCell.Offset(0, 1).Value

FirstArray = Split(CPET1, ",") ' creates the first array
SecondArray = Split(CPET2, ",") ' creates the second array

i = 0
x = FirstArray(i) ' first value of the first array
y = SecondArray(i) ' first value of the second array
CPETminProduct = x * y ' starting point for CPETmin

' this section manages arrays of different length by omitting the last values of the larger array
FirstArrayLength = UBound(FirstArray) + 1
SecondArrayLength = UBound(SecondArray) + 1
MinArrayLength = WorksheetFunction.Min(FirstArrayLength, SecondArrayLength)


For i = 0 To MinArrayLength - 1

x = FirstArray(i)
y = SecondArray(i)
xy = x * y
If CPETminProduct > xy Then CPETminProduct = xy
ActiveCell.Offset(0, 2).Value = CPETminProduct

Next