Regarding Excel Query
Hi,
Please find attachment which contains student database. i.e. master database. when student took admission, we entered it in this mastersheet only. so my requirement is i want a table which gives me centre and subject wise student count. for eg. if Mr.Ajay took admission for Subject 1 and subject 2 on Tilak Road centre then automatically count will be calculated. ultimately i want to know whether specific centre how many students are there? and also changes in master datsheet reflects in the respective table.(Plz. refer the mastersheet)
Please give me some inputs.
Attachment | Size |
---|---|
Trialadmission.xls | 42 KB |
- mandar's blog
- Login or register to post comments
- 2820 reads
Pivot tables and countif
hi
I suggest you take a look at Pivot tables and COUNTIF to resolve your problem.
Search this site for more information.
Rgds Nick