Compare 2 sheets - output in sheet 3 - Excel
Closed
vicgarin
Posts
1
Registration date
Thursday March 17, 2011
Status
Member
Last seen
March 17, 2011
-
Mar 17, 2011 at 08:58 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Mar 18, 2011 at 11:25 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Mar 18, 2011 at 11:25 AM
Related:
- Compare 2 sheets - output in sheet 3 - Excel
- Tentacle locker 2 - Download - Adult games
- Hitman 3 cheats - Guide
- Psiphon 3 download - Download - VPN
- Mark sheet in excel - Guide
- Five nights in anime 2 - Download - Adult games
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Mar 18, 2011 at 11:25 AM
Mar 18, 2011 at 11:25 AM
Hi vicgarin,
Formula for Sheet3 A1:
Formula for Sheet3 A2:
null
Can't see the logic in this, so I probably misunderstood you.
Can you explain where I took a wrong turn?
Best regards,
Trowa
Formula for Sheet3 A1:
=IF(AND(Sheet1!A2=Sheet2!A60,Sheet1!B2<>Sheet2!B60),Sheet1!A2,"")Formula for Sheet3 B1:
=Sheet1!B2Formula for Sheet3 C1:
=Sheet2!B60
Formula for Sheet3 A2:
=IF(AND(Sheet1!A3=Sheet2!A1233,Sheet1!B3=Sheet2!B1233),"",Sheet1!A4)Formula for Sheet3 B2:
=Sheet1!B4Sheet3 A1:
null
Can't see the logic in this, so I probably misunderstood you.
Can you explain where I took a wrong turn?
Best regards,
Trowa