If formula

[Horacio]

I´m tray to make a formula in column B1 that when I introduce data in
column A1 give me 1 and when I introduce data in A2 give me 2 in
column B2

A1 B1
15 1
25 2
30 3
30 4

Thank you

Horacio

 

[T. Valko]

Enter this formula in B1 and copy down as needed:

=IF(A1="","",COUNTA(A$1:A1))

--
Biff
Microsoft Excel MVP


I´m tray to make a formula in column B1 that when I introduce data in
column A1 give me 1 and when I introduce data in A2 give me 2 in
column B2

A1 B1
15 1
25 2
30 3
30 4

Thank you

Horacio

 

[tompl]

=IF(ISBLANK(A1),ROW(),"")

 

[tompl]

Oops, it should be like this:

=IF(ISBLANK(A1),"",ROW())

 

[Horacio]

Oops, it should be like this:

=IF(ISBLANK(A1),"",ROW())

Thank you
Works perfect

Horacio