sarahrosenberg
Board Regular
- Joined
- Aug 27, 2002
- Messages
- 190
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?
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?
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?
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?On 2002-10-15 14:39, paliman wrote:
It should be
="From "&MIN(A1:A20)&" to "&MAX(A1:A20)
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")
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")
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")