PDA

View Full Version : count no. of matching data in two excel



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

mohanvijay
02-02-2012, 04:33 AM
use COUNTIF or SUMPRODUCT function

shrivallabha
02-02-2012, 09:29 AM
You should use VLOOKUP to find this out.
Here's a reference for it:
http://office.microsoft.com/en-us/excel-help/vlookup-HP005209335.aspx

Bob Phillips
02-03-2012, 03:52 AM
SUMPRODUCT dear Henry, SUMPRODUCT

=SUMPRODUCT(--(ISNUMBER(MATCH(Sheet1!A1:A20,Sheet2!A1:A20,0))))

mohanvijay
02-03-2012, 04:04 AM
or like this

=SUMPRODUCT(--(COUNTIF(Sheet2!A1:A20,Sheet1!A1:A20)>0))