Categorywise

[sam51285]

ANYBODY HELP ME FOR CATEGORYWISE CERTIFICATE NO. DETAIL.

In attachment we have two sheet one is master and second one require data category(Key A/c,Normal,Govt Certificate Number detail.

[Sam Capricci]

from your limited info, see if this is what you want...

[popipipo]

Or you can use a pivot table

[sam51285]

let me know how to use pivot

[popipipo]

Google on
how to make a pivot table in excel
and I found this:
http://www.youtube.com/watch?v=IaOtCWxx3xU
Take a look at it

[Sam Capricci]

this is incorporates a pivot table. Still not sure what you want to show...