absolute references

[scott]

I have the following formulas(about 18000 cells):
=if(a1>=1,1,"")
=if(a1>=2,1,"")
=if(a1>=3,1,"")
=if(a1>=4,1,"")
and so on. I have typed all the formulas in but now need
to make all 18000 cells absolute references. Is there a
semi fast way to do this. Thanks

 

[Arvi Laanemets]

Hi

I have the following formulas(about 18000 cells):
=if(a1>=1,1,"")
=if(a1>=2,1,"")
=if(a1>=3,1,"")
=if(a1>=4,1,"")
and so on. I have typed all the formulas in but now need
to make all 18000 cells absolute references. Is there a
semi fast way to do this. Thanks

All 18000 formulas!!!

OK, you got your answer from Darren, but for future:

When you have your formulas p.e. in column A and starting p.e. from cell A3

A3=IF($A$1=ROW(A3)-ROW($A$2),1,"")

and copy the formula down as much as you need.


Arvi Laanemets