Min Max on string

[John]

Hi there,

Can anyone tell me if the Min Max shapesheet functions can take a cell
reference? I've got the following User defined cells:

User.List ="10,12,14,20"
User.Min ="MIN(User.List)"
User.Max ="MAX(User.List)"

In this situation, User.Min and User.Max evalute to 0 (rather than 10 and 20
respectively). I assume this is because they are seeing User.List as a
string?

Is there a way round this?

Thanks in advance.

Best regards

John

 

[David Parker]

Yes and Yes, eg:

User.Min=MIN(INDEX(0,User.List,","),INDEX(1,User.List,","),INDEX(2,User.List,","),INDEX(3,User.List,","))

 

[John]

Hi David,

Thanks for this. Makes for a long formula if you have a long array!

Best regards

John

 

[David Parker]

Fortunately they can be as long as you like.... and it would be shorter if
you used ";" as a list seperator because this is the default in Visio,
therefore you can omit the third argument to INDEX()

 

[John]

Will convert to ";" immediately!

Thanks David

Fortunately they can be as long as you like.... and it would be shorter if
you used ";" as a list seperator because this is the default in Visio,
therefore you can omit the third argument to INDEX()