Consolidated report using formula

[rajeshd]

Hi I have a sheet which contains the following columns

Name Course Contacted Admitted
Rohit BBA y y
Rana BBA
Ritu BCA y



I want to report as

Course Count(Contacted) Count(Admitted)
BBA 1 1
BCA 1

 

[NARAYANK991]

Hi Rajesh ,

See if this is OK.

Narayan

 

[rajeshd]

Thanks