View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ben simpson
 
Posts: n/a
Default 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?