View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Compare 2 sets of data

Did you try the previous response to your original post?
Did it give you the expected results?

As to your new setup/query,
Try in D2: =IF(C2="","",C2=B2)
Copy down

The above will return results that tally 99.9% with those you posted, except
for D8, where it'll return TRUE instead of your indicated FALSE. The
consistent logic applied points to TRUE as being the correct return for D8,
hence think you might have a typo in your D8's FALSE as posted.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---