Hi
create duplicate copy of the sheet you are working by right clicking
that sheet tab then select/click 'move or copy' and check the small box
below asking to create copy .
use sort from Data menu and complete the steps in the created new
worksheet
then use Data Subtotals
u will get the required information in the copied (duplicate) sheet
change the name of duplicate sheet which looked like Sheet1(2)
with regards
Gandhi
--
gandhi318Posted from -
http://www.officehelp.in