Comparing ranges:

[Guest]

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?

 

[Peo Sjoblom]

Can you use countif?

=IF(COUNTIF(Named_Range,B2)>0,1,0)

where B2 would be the first cell you check if it occurs in the named range,
copy down along the date range and you'll get 1 for hit and zero if not
found

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon