Thread: COUNT
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Stefi Stefi is offline
external usenet poster
 
Posts: 2,646
Default COUNT

You are welcome! Thanks for the feedback!
Stefi

€˛puiuluipui€¯ ezt Ć*rta:

YOU ARE GREAT.
IT WORKS!
THANKS.

"Stefi" a scris:

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:

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.