M
Montu
I have 25000 data in Sheet 1 which is application of an exam like as follows:
A B C D
E F
Reg. No. Roll Name Address
City Pin
002848 5623 RAKESH AGARWAL DE-105/2 NARAYAN TALA, RANCHI 834005
002284 5257 ANJU KUMAR SARVESHWARI NIKETAN, PATNA 800001
005090 5721 SULATHA KUMARI 82/A BONDEL ROAD GHATAL 110020
001506 5120 RAJAT PARASRAM 18/B BIPRADAS STREET S. NAGAR 743127
001501 5019 SIDHARTHA KHER 25B, J. BASAK ROAD KULTI
831012
005092 5818 SUSANTA SAHA BH-6, SECTOR II C. NAGAR 712136
003346 5517 GOBINDI DEVI 730, BLOCK-A JALEM 744101
Continued .....
I have 2500 data in Sheet 2 which is exam result (fail) like as follows:
A B
Reg. No. Roll
002561 5257
002624 5481
000045 5019
000926 5116
000954 5062
001618 5263
002757 5454
Continued .....
after that I insert two column in between B & C column of sheet 1 to put the
whole number of sheet 2 in the insert column as above in sheet 1. Now I want
to match the number of sheet 1 with sheet 2. If sheet 1 number is match with
sheet 2 then all corospondence data (like Address, City, Pin, etc.) of the
match number in sheet 1 will be delete.
is there any formula not macro in excel. Please help me.
A B C D
E F
Reg. No. Roll Name Address
City Pin
002848 5623 RAKESH AGARWAL DE-105/2 NARAYAN TALA, RANCHI 834005
002284 5257 ANJU KUMAR SARVESHWARI NIKETAN, PATNA 800001
005090 5721 SULATHA KUMARI 82/A BONDEL ROAD GHATAL 110020
001506 5120 RAJAT PARASRAM 18/B BIPRADAS STREET S. NAGAR 743127
001501 5019 SIDHARTHA KHER 25B, J. BASAK ROAD KULTI
831012
005092 5818 SUSANTA SAHA BH-6, SECTOR II C. NAGAR 712136
003346 5517 GOBINDI DEVI 730, BLOCK-A JALEM 744101
Continued .....
I have 2500 data in Sheet 2 which is exam result (fail) like as follows:
A B
Reg. No. Roll
002561 5257
002624 5481
000045 5019
000926 5116
000954 5062
001618 5263
002757 5454
Continued .....
after that I insert two column in between B & C column of sheet 1 to put the
whole number of sheet 2 in the insert column as above in sheet 1. Now I want
to match the number of sheet 1 with sheet 2. If sheet 1 number is match with
sheet 2 then all corospondence data (like Address, City, Pin, etc.) of the
match number in sheet 1 will be delete.
is there any formula not macro in excel. Please help me.