If formula

  • Thread starter Thread starter Horacio
  • Start date Start date
H

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
 
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
 
Back
Top