Max Min Differnce in a Range
Jackpot! Thanks
"Harlan Grove" wrote:
Albert H. Bell wrote...
I have the same problem with your formula. If the Int Formula contains more
than 1 date I return #Value.
"Harlan Grove" wrote:
....
=MIN(IF(INT(A$2:A$10)=E1,A$2:A$10))
....
=MAX(IF(INT(B$2:B$10)=E1,B$2:B$10))
Then you didn't enter the formula as an array formula. To do so, you
need to hold down a [Ctrl] key and a [Shift] key before pressing the
[Enter] key.
|