| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selecting most recent data within several lines of data | Excel Discussion (Misc queries) | |||
| 24 lines between data | Excel Discussion (Misc queries) | |||
| Inserting Lines or Copying lines with formulas but without data | Excel Discussion (Misc queries) | |||
| index,match,match on un-sorted data | Excel Worksheet Functions | |||
| The match and lookup functions can find literal data but not the same data referenced from a cell | Excel Discussion (Misc queries) | |||
Threaded Mode
