Min and Max Functions returning a 0 value when looking up a formula

[stroffso]

Hi,

I have the following formulas in cells FQ3 and FR3 which return the numbers 16 and 19 repsectively
=IFERROR(LEFT(INDIRECT(FQ$1&$DZ3),(FIND("-",INDIRECT(FQ$1&$DZ3),1)-1)),"")
=IFERROR(RIGHT(INDIRECT(FQ$1&$DZ3),(FIND("-",INDIRECT(FQ$1&$DZ3),1)-1)),"")

However I then want a formula that returns the numbers in order lowest to highest. This is the formula I have
=MIN(FQ3:FR3)&"-"&MAX(FQ3:FR3)

However when I do this it returns 0-0

Obviously there is something where the min and max formulas dont like looking up another formula, is there a way around this? I also tried large and small but the same outcome?

 

[Michael M]

I don't have excel at the moment, but the formulas that return 16 & 19 look like they are returning the numbers as Text ?
Which will give you the 0-0 result in the Min / Max formula

 

[AhoyNC]

As pointed out by Michael M your formulas are returning TEXT and not numeric values.
You could try changing your formula to:
This would be an array formula that must be entered with CTRL-SHIFT-ENTER.
=MIN((FQ3:FR3)*1)&"-"&MAX((FQ3:FR3)*1)

 

[stroffso]

As pointed out by Michael M your formulas are returning TEXT and not numeric values.
You could try changing your formula to:
This would be an array formula that must be entered with CTRL-SHIFT-ENTER.
=MIN((FQ3:FR3)*1)&"-"&MAX((FQ3:FR3)*1)

Worked an absolute charm thanks so much

 

[Michael M]

That might also have a positive effect on your other thread involving COUNTIF ??

 

[stroffso]

That might also have a positive effect on your other thread involving COUNTIF ??

Yes I was thinking that so how do i change the countif similarly to suit? it only appears to be those 2 combination of numbers that are double counting which is very odd

 

[Michael M]

See my post on the other thread using SUMPRODUCT

 

[stroffso]

Sorry it came up in a weird way and I didnt actually notice the formula in there. That again has worked a charm sincere thanks

 

[Michael M]

Yeah, sorry about that....I pasted instead of code tagging.....