How to compare data between two tables
Closed
Stace
-
Jul 14, 2009 at 05:18 AM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Jul 16, 2009 at 11:37 PM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Jul 16, 2009 at 11:37 PM
Related:
- How to compare data between two tables
- Transfer data from one excel worksheet to another automatically - Guide
- How to check t mobile data - Guide
- How to be offline in whatsapp when data is on - Guide
- Compare two worksheets and paste differences to another sheet - excel vba free download ✓ - Excel Forum
- Amd data change update new data to dmi ✓ - Windows 10 Forum
2 responses
Excelguru
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Jul 16, 2009 at 11:37 PM
Jul 16, 2009 at 11:37 PM
use =countif(RangeSecondTable, "=" & useridFirstTable) if greater than 0 then it means the userid exists
so put a IF statement to above to copy your data
so put a IF statement to above to copy your data
Excelguru
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Jul 16, 2009 at 11:37 PM
Jul 16, 2009 at 11:37 PM
use =countif(RangeSecondTable,"=" & useridFirstTable) if greater than 0 then it means the userid exists
so put a IF statement to above to copy your data
so put a IF statement to above to copy your data
