Increasing Number

**jatolo** · 03-07-2014, 03:57 PM

Is it possible to have the number 1 increases every time a paste this formula? =IF(C1="","",IF(C1<>"",1))... C3 =1 , D3=2, G3= 3... Etc.

**Ron Coderre** · 03-07-2014, 04:00 PM

Can you post a sample workbook that shows what you want to do?

**AlKey** · 03-07-2014, 04:01 PM

Maybe this one

=IF(C1="","",ROWS($A$1:A1))

**popipipo** · 03-07-2014, 04:04 PM

Without a example I should say try something with 'column(a1)'

the result of column(a1)=1
Drag to the right: column(b1)
the result of column(b1)=2

Re: Increasing Number