Max Min Differnce in a Range
Harlan,
I have the same problem with your formula. If the Int Formula contains more
than 1 date I return #Value.
"Harlan Grove" wrote:
Shane Devenshire wrote...
....
=MIN(IF(DATE(YEAR(A$2:A$10),MONTH(A$2:A$10),DAY(A $2:A$10))=E1,A$2:A$10,""))
=MAX(IF(DATE(YEAR(B$2:B$10),MONTH(B$2:B$10),DAY(B $2:B$10))=E1,B$2:B$10,""))
....
Why not just
=MIN(IF(INT(A$2:A$10)=E1,A$2:A$10))
and
=MAX(IF(INT(B$2:B$10)=E1,B$2:B$10))
?
|