thanx alot this is exactly what i am looking for

"Arvi Laanemets" wrote:

Hi again

You can do it with a single formula for range B1:M1 too:
B1=ROUND((2*$A$1-SUM($A$1:A$1))/(12-COLUMN()+2),3)
and copy to B1:M1


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )