Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula help
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 |