LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Comparing Named ranges apologies for the dodgey post below Sam Crump Excel Worksheet Functions 5 March 7th 06 12:52 PM
Comparing two data ranges for differences. jason.r.swinehart Excel Discussion (Misc queries) 0 January 12th 06 07:50 PM
Comparing ranges and deleting sktnggtr Excel Worksheet Functions 0 September 13th 05 04:01 PM
How to : Comparing Two Ranges lockwood7 Excel Worksheet Functions 3 August 3rd 05 01:43 PM
comparing multiple ranges Steve Excel Discussion (Misc queries) 1 April 27th 05 07:38 PM


All times are GMT +1. The time now is 10:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"