View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Henrik T Henrik T is offline
external usenet poster
 
Posts: 1
Default Match Data on different lines

Hi.

I have a document with bills imported from two different databases.
I'm trying to compare the value from for example C2 with H2 and if it isn't
a match i need to compare C2 with H3, H4 etc, until it fines a match (the
problem is that the data from one database misses about 500 of 2000 bills).

Is this possible to do with a macro or advanced filter?

Henrik