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
- Tmobile data check - Guide
- Beyond compare - Download - File management
- Display two columns in data validation list but return only one - Guide
- Gta 5 data download for pc - Download - Action and adventure
- Transfer data from one excel worksheet to another automatically - Guide
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
