Thanks alot !
Can you also tell me how to modify formula, if I want to put the formula in
some other sheet say sheet3 and data is present in sheet1?

Regards,
Sandeep

"Max" wrote:

A simple formulas play which should deliver it for you

Assuming source data in cols A & B, in row 2 down
In C2:
=IF(A2="","",IF(COUNTIF(A$2:A2,A2)1,"",ROW()))
Leave C1 blank

In D2:
=IF(ROWS($1:1)COUNT(C:C),"",INDEX(A:A,SMALL(C:C,R OWS($1:1))))

In E2:
=IF(D2="","",SUMIF(A:A,D2,B:B))
Select C2:E2, copy down to cover the max expected extent of data in col A,
say down to E500? Minimize/hide away col C. Col D will return a dynamic
unique list of the names from col A, while col E returns the corresponding
total earnings
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"sandeep singh" wrote:
Can I write a dynamic formula based on the different kind of data present in
a particular column and which generates results dynamically depending on the
data being added?

Eg;
Suppose my coulmn contains a list of items.

Emp_name Earning
A 10
A 20
A 20
B 20
C 30
D 5
D 10

I want to write a formula which dynamically generates the earnings of
employees by taking unique names from the column

Say If a some adds one more Employee E, the total earnings for employee E
should automatically get generated at some cell along with his name.

Is this possible in excel?

Thanks in advance,
Sandeep