In c2 (headers in Row 1???):
=IF(COUNTIF($A$2:A2,A2)1,"",B2/COUNTIF(A:A,A2))


Hardeep_kanwar wrote:

Hi! Everybody

I have a data Like This
Column A ColumnB
Abc 50
Abc 50
Def 80
Def 80
Def 80
xyz 42
xyz 42
xyz 42
xyz 42
Pqr 10

Now i want to Divide each data like ABC=50 in 2 row i want to Divide 50/2
Def=80 in 3Rows i want to Divide 80/3
Xyz=42 in 4Rows i want to Divide 42/4
And Pqr=10 want to Divide 10/1

Like This:
Column A ColumnB column C
Abc 50 25
Abc 50
Def 80 26.66666667
Def 80
Def 80
xyz 42 10.5
xyz 42
xyz 42
xyz 42
Pqr 10 10

Sometimes Some data goes to 30 or even40.Actually it depend on the numbers
of data i have if i have 20 rows with same data then divide by 20
If18 then divide by 18 and so on

I don't want to Delete any data

Any help will be Appreciated

Thanks in Advance

Hardeep kanwar

--

Dave Peterson