Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determining repeated cells between two workbooks
Hello. I have three columns in two separate workbooks. I wish to find out which cells are different in workbook B given workbook A. I'm really not sure how to explain it, so I will provide an example Workbook A 110 6/20 73 110 7/01 93 110 8/04 82 140 6/15 24 140 7/10 11 Workbook B 110 6/20 99 110 7/03 93 110 7/22 11 110 8/04 82 140 6/15 24 First, I look at the first row from Workbook B. The first column shows 110, so I want to first make sure 110 exists in Workbook A. If it does, then I look at the second column, which is 6/20. I look over at workbook A, and make sure 6/20 exists in the second column where the first column is also 110. (if 6/20 exists, but 110 is NOT in column A, that does NOT count). Then I check out the third column, it shows 99, and try to find 99 in workbook A where column A = 110, and column B = 6/20. If workbook B shows something different, then I want to highlight that cell. So in this example: 99, 7/03, 7/22, 11 from Workbook B will be highlighted. Anyone know of any built-in Excel functions or any VBA way to do this? Thanks in advance! (if my question is unclear, please let me know and I will try to clear it up) -- farful ------------------------------------------------------------------------ farful's Profile: http://www.excelforum.com/member.php...o&userid=36172 View this thread: http://www.excelforum.com/showthread...hreadid=559519 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determining repeated cells between two workbooks
Assume Sheet1 and Sheet2. In D1 of sheet1
=if(Sumproduct(--(Sheet2!$A$1:$A$100=A1),--(Sheet2!$B$1:$B$100=B1),(--(Sheet2!$C$1:$C$100=C1))=0,"<==Unique","") then drag fill down the column. Similar in Sheet2 If you really need the cells highlighted, then use conditional formatting with such a formula. -- Regards, Tom Ogilvy "farful" wrote in message ... Hello. I have three columns in two separate workbooks. I wish to find out which cells are different in workbook B given workbook A. I'm really not sure how to explain it, so I will provide an example Workbook A 110 6/20 73 110 7/01 93 110 8/04 82 140 6/15 24 140 7/10 11 Workbook B 110 6/20 99 110 7/03 93 110 7/22 11 110 8/04 82 140 6/15 24 First, I look at the first row from Workbook B. The first column shows 110, so I want to first make sure 110 exists in Workbook A. If it does, then I look at the second column, which is 6/20. I look over at workbook A, and make sure 6/20 exists in the second column where the first column is also 110. (if 6/20 exists, but 110 is NOT in column A, that does NOT count). Then I check out the third column, it shows 99, and try to find 99 in workbook A where column A = 110, and column B = 6/20. If workbook B shows something different, then I want to highlight that cell. So in this example: 99, 7/03, 7/22, 11 from Workbook B will be highlighted. Anyone know of any built-in Excel functions or any VBA way to do this? Thanks in advance! (if my question is unclear, please let me know and I will try to clear it up) -- farful ------------------------------------------------------------------------ farful's Profile: http://www.excelforum.com/member.php...o&userid=36172 View this thread: http://www.excelforum.com/showthread...hreadid=559519 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing text in a repeated cell/row that is longer than repeated | Excel Discussion (Misc queries) | |||
Determining which cells are locked. | Excel Worksheet Functions | |||
Delete repeated Cells | Excel Worksheet Functions | |||
Determining if Other Workbooks Are Open | Excel Programming | |||
highlighting cells if value is repeated | Excel Programming |