Searching for data in another sheet that match the conditions
For example i take first line name:cristine...years:3.....place:A. I must insert a function that looks in sheet 2 for the same parameters cristine 3 A, and count how many they are and put the count number in the count column. In this sample the result is 2:count=2. Next for michael 3 A :count=1
Any help would be greatly appreciated.
Thank you.
Regards,
Michael
Attachment | Size |
---|---|
Sample1.xlsx | 10 KB |
have you looked at using a
have you looked at using a pivot table ?
http://excelexperts.com/Teach-Yourself-Excel-Lesson-25-Create-A-Pivot-Table
and:
http://excelexperts.com/Excel-Tips-Pivot-Tables-for-dummies