Notifications
Clear all
General Excel Questions & Answers
7
Posts
4
Users
0
Reactions
81
Views
Topic starter
Hi Friends
Students are paying fee in installment. That's why student name and subject is repeating in attached file.
I want to know how many courses has taken by single student.
I need help to put formula in column L of attached file to get the desired result.
Regards
Suhail
Posted : 25/11/2017 8:08 am
Hi Suhail
See if this helps.
Please note that these are array formulas.
Sunny
Posted : 25/11/2017 8:29 pm
L2=SUM((A$2:A$14=K2)/COUNTIFS(A$2:A$14,A$2:A$14,B$2:B$14,B$2:B$14))
Ctrl+shift+enter run the formula
Posted : 26/11/2017 9:08 am
You may also try this
=SUM((A$2:A$14=K2)*(MATCH(A$2:A$14&B$2:B$14,A$2:A$14&B$2:B$14,)=ROW($1:$13)))
Posted : 26/11/2017 9:17 am
Pivot table solution
Posted : 26/11/2017 9:22 am
Love that last one! (The pivot table solution)
Posted : 26/11/2017 10:46 am
Topic starter
Thanks all of you for your support
Regards
Sohail
Posted : 30/11/2017 4:23 am
