Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a 3 sheet file. Sheets 1 and 2 are exactly the same. There is an
SSN and an amount in each sheet. something similar to the following. Ssn 123 Ssn 222 Ssn 222 Ssn 555 Ssn 333 Ssn 444 Ssn 666 I need sheet 3 to contain the SSNs and the amounts of the values where sheet 1 and sheet 2 are different. So if sheet 1 had an ssn of 123-45-6666 and an amount of 1.23, and sheet two had the same ssn and an amount of 3.43, i would need this ssn and amount populated in sheet 3. Any suggestions??? Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Cost Comparison Spread Sheet | Excel Discussion (Misc queries) | |||
Using a comparison and taking data from one sheet and putting it i | Excel Worksheet Functions | |||
comparison | Excel Worksheet Functions | |||
XLS comparison | Excel Discussion (Misc queries) | |||
Comparison | Excel Worksheet Functions |