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
- 3209 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