Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Matching data in separate lists
I am attempting to match the data in two separate tables based on single cell. For instance an amount and its date comprise a table, am trying to write a formula to tell me which of these amounts appea in the other table (or do not), the date needs to stay attached to th amount but is not relevant. I have written one using the excel matc function but the problem is duplicate values. For instance, if ther is the amount $100 more than one time it matches them all, I want it t only match once so that there has to be one $100 in each table to creat a match. I have tried the DigDB match table function and I cannot see to get it to work. Any ideas -- happymeal0 ----------------------------------------------------------------------- happymeal02's Profile: http://www.excelforum.com/member.php...fo&userid=1682 View this thread: http://www.excelforum.com/showthread.php?threadid=32017 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return Data Matching Criteria in a separate spreadsheet | Excel Worksheet Functions | |||
matching data on two separate worksheets | Excel Discussion (Misc queries) | |||
compare data in two lists to find matching entries | Excel Discussion (Misc queries) | |||
compare data in two lists to find matching entries | Excel Discussion (Misc queries) | |||
compare data in two lists to find matching entries | Excel Discussion (Misc queries) |