rajagopal
02-02-2012, 03:19 AM
Hi,
I've 2 excels - Excel 1, column C has 500 student IDs and Excel 2, column Y has 300 student ids. Likewise i've the data in 6 sheets in both excel.
I want to know how many no. of student id as given in excel 1 is present in excel 2 in every sheets..
Please help
I've 2 excels - Excel 1, column C has 500 student IDs and Excel 2, column Y has 300 student ids. Likewise i've the data in 6 sheets in both excel.
I want to know how many no. of student id as given in excel 1 is present in excel 2 in every sheets..
Please help