grouping data

Originally Posted by 1964raju

Please Login or Register  to view this content.

all the names should be grouped & totalled as per the year
is there any formula or function

How about putting that data into a worksheet and attach it so we can see what you really mean. Try to include a much better description of what you're trying to accomplish.

Originally Posted by 1964raju

name 1997 1998 1999 total
raju 1
venu 2
somu 2
raju 5
rani 3
venu 3
somu 3

all the names should be grouped & totalled as per the year
is there any formula or function

Look into Pivot Tables

http://www.datapigtechnologies.com/ExcelMain.htm