Comparing ranges:
I have to compare two sets of data. One is a named range, and the other a
date range. I need to find a way to compare these ranges, matching the one
number (date to be precise), that matches in these ranges, and give a 1 if
true and a 0 if false when they both match the current day. I'm just lost
here. Any ideas out there?
|