absolute references

  • Thread starter Thread starter scott
  • Start date Start date
S

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
 
Hi


scott said:
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
Click to expand...

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
 
Back
Top