please guys,
I have a problem and i need help urgently..
I have 2 columns in one sheet withe the fallowing data:
col1: contains a 7 digit numbers
col2: contains "amount" also around 6 didgits
The rows might reach 8000 rows
for example:
sheet1
Col 1 col2
1. 251401 100000
2. 251403 50000
3. 251404 2500
4.
5.
Sheet 2:
Col 1 col2
1. 251404 2500
2. 251403 50000
3. 123 77777 <----- I need to get the rows that does not match
4. 251401 100000
.
In Sheet 2 i have the same columns but less rows and not sorted with also the same data (matched) and some data that doesnt match.
my problem is:
i want Excel to search for the data in Sheet 2 in sheet 1 and match them.
one if these solution if possible will satisfy me:
1. even to sort the data to be against each other and the rest unmatched item to be at the end of the rows
or
2.or if not possible:
to highlight the same data in sheet 1 with the same data in sheet 2 so i can cut them and paste them in another sheet and the remaining items will be my answer.
-------------------------------------------
Col 1 col2 col3 col4
1. 251401 100000 251401 100000
2. 251403 50000 251403 50000
3. 251404 2500 251404 2500
4. 123 77777
Any Help would be highly appreciated ..
Thanking you in advance
Bookmarks