Need help with function

  • Thread starter Thread starter LLC
  • Start date Start date
L

LLC

I am creating a spreadsheet where lets say cell B2 is my
variable, lets say the number 20. I want column "A" to
list the numbers 1-20 sequencially(from cell A4-A23). If
I change the number in cell B2 to 30, I want the list of
numbers to automatically change to 1-30. Can anyone tell
me how this can be done?
 
Hi
one way: Enter the following in A4
=IF(ROW()-3<=$B$2,ROW()-3,"")
and copy this down
 
Hi
Thanks for your help!!!
-----Original Message-----
Hi
one way: Enter the following in A4
=IF(ROW()-3<=$B$2,ROW()-3,"")
and copy this down

--
Regards
Frank Kabel
Frankfurt, Germany

.
Click to expand...
 
Back
Top