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.

 

 

AttachmentSize
Trialadmission.xls42 KB
Nick's picture

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