M mshel May 26, 2004 #1 I want to calculate the maximum and minimum value from a series of numbers using a single formula. Is this possible?
I want to calculate the maximum and minimum value from a series of numbers using a single formula. Is this possible?
P Peo Sjoblom May 26, 2004 #2 =MAX(Range)&" "&MIN(Range) -- For everyone's benefit keep the discussion in the newsgroup. Regards, Peo Sjoblom
=MAX(Range)&" "&MIN(Range) -- For everyone's benefit keep the discussion in the newsgroup. Regards, Peo Sjoblom
