Hi I have two worksheets but have a same column named "Admin No.". I will need to compare the 2 "admin no." column.
Example:
Worksheet 1
Admin No.Name
1111 Ali
2222 James
3333 Janet
4444 Lihua
5555 Ting Ting
6666 Jasmine
Worksheet 2
Admin No.Name
1100 Alvin
2200 John
3300 Mavis
4411 Haoyi
5555 Ting Ting
6677 Jason
I will ike to compare both "admin no." column and when worksheet 1 5555 can be find in worksheet 2, it will return True. 6666 cannot find in worksheet 2 then it will return false.