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

Enter this formula in B1 and copy down as needed:

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

--
Biff
Microsoft Excel MVP


"Horacio" wrote in message
...
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

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

"Horacio" wrote:

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
.

Oops, it should be like this:

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

"Horacio" wrote:

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
.

On 23 Fev, 00:57, tompl wrote:
Oops, it should be like this:

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



"Horacio" wrote:
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
.
Thank you
Works perfect

Horacio