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)