Prev: logical (if a1=specific word, can c1 = value entered in a2?)
Next: How do I get the formula icon back on my toolbar?
From: Matt Geare on 21 Apr 2010 22:23
Hi Gisela,

I normally do it the way Pete has suggested too, but you can also reference
the ROW formula.

E.g. If you want A1 to equal 1 then formula is simply =Row().

But if you want A1 to equal 100 then formula is =Row()+99.

You can drag these formulas down for as many rows a you require.

Cheers,

Matt

"Pete_UK" wrote:

> Put your starting number in A1 (eg 1). Put this formula in A2:
>
> =A1+1
>
> Then copy that formula down column A for as many rows as you need.
>
> Hope this helps.
>
> Pete
>
> On Apr 21, 11:16 pm, Gisela Pacheco <Gisela
> Pach...(a)discussions.microsoft.com> wrote:
> >
>
> .
>
 | 
Pages: 1
Prev: logical (if a1=specific word, can c1 = value entered in a2?)
Next: How do I get the formula icon back on my toolbar?