Return Unquie Values
Javier Diaz wrote...
....
. . . Remember, we're messing with dates that are lookedup not hard
keyed.
....
So are they just dates or dates with times but formatted to show only
the date portion? Check using the formula
=SUMPRODUCT(SIGN(MOD(H$20:H$44,1)))
If this returns 0, then there are dates with times in H20:H44. If
you want to treat them as dates alone, change all references to H$2:H
$44 to INT(H$2:H$44).
|