COUNT

[puiuluipui]

Hi, i want to count rows, but only when i write something.
In column A i want the number to appear when i write something in column B

ex

A B
1 nrt crt product
2 1 something
3 2 something
4 nothing



When i write something in B2, i need number 1 to apeear in A2, and start
counting in A3, A4,...etc, but only when i write something in the next cell

If i delete B3 or another filled cell in column B, the count to dissapear.
Can it be done?

THANK YOU IN ADVANCE.

 

[Stefi]

Maybe
=IF(ISBLANK(B2),"",ROW()-1)

in A2 (although this is not a real counting, it's only showing the row
number of filled cells in column B).

Regards,
Stefi

„puiuluipui†ezt írta:

 

[puiuluipui]

YOU ARE GREAT.
IT WORKS!
THANKS.

"Stefi" a scris:

 

[Stefi]

You are welcome! Thanks for the feedback!
Stefi

„puiuluipui†ezt írta:

 

[puiuluipui]

Stefi, i know this is another question, but, can i make something like google
search? When i write something, the cell to give me a hint? Not really a drop
down list, something more like google search bar. i don't know how to explain
better. I'm sure you understand.

THANKS ALLOT FOR EVERYTHING!

"Stefi" a scris:

 

[muddan madhu]

try this

=IF(B2="","",COUNTA($B$2:B2)) and drag it down

 

[puiuluipui]

THANKS MUDDAN. IT WORKS.
THANKS!

"muddan madhu" a scris:

 

[puiuluipui]

Or something like a shotcut.
Database:
Central European 265
Central European 75
Central European 365

I have to write Central European.
So, i type Cen Eur, and the hint to show me all the words that begins with
Cen Eur.


Can it be done?
Thanks!

"puiuluipui" a scris:

 

[Stefi]

Sorry, I don't know such a facility!
Stefi


„puiuluipui†ezt írta:

 

[puiuluipui]

Thanks anyway.
Thanks for everything!

"Stefi" a scris: