Auto fill Numbers

[srizki]

Can any one help me I need a formula, that fills numbers if the corresponding cell has a value. So if B3 has firs value A3 will fill 1, and B6 has second value A6 will fill 6, so one.
I knew this formula, it was =COUNTA formula.

Thanks

 

[NBVC]

Do you mean perhaps?

=If(Isnumber(A1),row(A1),"") copied down.

 

[srizki]

No, it was something like, if I enter any number or text in a cell say B8, A8 fills the serial number, and if I fill next in B12 A12 fills 2, in it, so it is like IF B8>"", FILL 1 OR LEVE IT BLANK. so on. It will leave cell blank if the corresponding cell is empty or increase the number by one.

 

[NBVC]

Then maybe?

=IF($B1<>"",COUNTA($B$1:$B1),"") copied down

 

[srizki]

THANK YOU VERY MUCH,
This is one of my favourite formulas. I will not foget it again.
thanks again NBVC