Combining text and results

[sarahrosenberg]

I am trying to display the min and max of a column in one cell. For example, the cell would read "From (MIN) to (MAX)" Is this possible?

 

[Aladin Akyurek]

On 2002-10-15 14:36, sarahrosenberg wrote:
I am trying to display the min and max of a column in one cell. For example, the cell would read "From (MIN) to (MAX)" Is this possible?

="From "&MIN(Range)&" to "&MAX(Range)

With parens...

="From ("&MIN(Range)&") to ("&MAX(Range)&")"

 

[paliman]

It should be

="From "&MIN(A1:A20)&" to "&MAX(A1:A20)

 

[Mark W.]

On 2002-10-15 14:36, sarahrosenberg wrote:
I am trying to display the min and max of a column in one cell. For example, the cell would read "From (MIN) to (MAX)" Is this possible?

Yes.

 

[sarahrosenberg]

Pali, Your formula worked great except for one thing. I am trying to display a range for a field that contains dates. When I used your formula, it converted the dates into a 5-digit number string. Do you know how to fix this?

 

[Mark W.]

="From "&TEXT(MIN(A1:A20),"m/d/yy")&" to "&TEXT(MAX(A1:A20),"m/d/yy")

 

[sarahrosenberg]

On 2002-10-15 14:39, paliman wrote:
It should be

="From "&MIN(A1:A20)&" to "&MAX(A1:A20)

Pali, Your formula worked great except for one thing. I am trying to display a range for a field that contains dates. When I used your formula, it converted the dates into a 5-digit number string. Do you know how to fix this?

 

[sarahrosenberg]

On 2002-10-15 14:49, Mark W. wrote:
="From "&TEXT(MIN(A1:A20),"m/d/yy")&" to "&TEXT(MAX(A1:A20),"m/d/yy")

Perfect. Thank you!

 

[sarahrosenberg]

On 2002-10-15 14:49, Mark W. wrote:
="From "&TEXT(MIN(A1:A20),"m/d/yy")&" to "&TEXT(MAX(A1:A20),"m/d/yy")

Perfect. Thank you!

 

[sarahrosenberg]

On 2002-10-15 14:49, Mark W. wrote:
="From "&TEXT(MIN(A1:A20),"m/d/yy")&" to "&TEXT(MAX(A1:A20),"m/d/yy")

Perfect. Thank you!