find missing dates
"wally" wrote in message
...
i am trying to creat a sub list of dates that are not contained in the
first
list. i have a list of dates. say 1/105 through today. however, there
might be some dates missing in the list. i would like to create a list of
those dates on a form. if i need to do this on the worksheet i can.
have you tried "match()" function
let column_a contains your dates, column_b all range you test for existence,
column_c put formula:
=match(b1,a$1:a$999,0)
this formula will return either found position, or
"error" for missing date
|