Excel 2007 : How to manipulate array that displays 12:00 AM to a blank ""

[harry1013]

Hi all,

Currently, I am using this formula {=IF(F1=F2,"",MAX(IF($F$1:$F$100=F1,$D$1:$D$100)))}. Column F are different states/regions (i.e. LA, Detroit, Dallas) while column D are times (i.e. 8:21 AM, 10:03 AM). The way the formula works now is if there is a blank in column D, it will put it as 12:00 AM. For some reason, I can't write a simple if to make the field blank instead of 12:00 AM. Any ideas?

Thanks,

-h