i need your help

[mangesh]

i am providing you with my problem with an excel attachment file please
reply me asap.

Attachment filename: help me.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=463626

 

[Andy B]

Hi

I would suggest using Data / Filter / AutoFilter. This is a very simple yet
effective way of doing what you want.
If you need to create separate 'tables' you can use the Advanced Filter

Andy.

 

[Norman Harker]

Hi Mangesh!

Take a look at Pivot tables. See:

Jon Peltier hosted intro to Pivot tables by Debra Dalgleish
http://peltiertech.com/Excel/Pivots/pivotstart.htm

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.