Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looking to subtract one list of values from another
Hi,
If someone could heelp me with this you could save my friday for me!! I have a problem in this format (man it's hard to articulate this) worksheet1 has 4 columns and 10 rows of data. worksheet2 has 4 columns and 20 rows of data. I know that that rows in worksheet1 are duplicated in worksheet2, so I need to "subtract" one set from the other to leave the unduplicated records. I should point out that some rows are common for both workbooks but not duplicated.....i.e. the first workbook contains, let's say 3 A's, the second contains 4 A's but only the 3 of these are duplicate. If you can understand any of what I've written and have any suggestions, they'd be gratefully received. Paul |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trying to subtract the two lowest values from a row of numbers | Excel Worksheet Functions | |||
Subtract a value from list | Excel Discussion (Misc queries) | |||
Formula to subtract values in one cell only... | Excel Worksheet Functions | |||
Formula to subtract values in one cell only... | Excel Worksheet Functions | |||
How do I add/subtract hours and minutes when some values exceed 2. | Excel Discussion (Misc queries) |