Auto numbering

[Manos]

Dear all
I need assist for couple of functions.
Two same problems with different perspective:
1) I have in column B sum entries like
B1 Aplle
B2 Orange
B3
B4 Apple

How is it possible in column A to run a function which will count
automaticaly only the rows of column B that have input. In the previous
example i want to get for B1=1, B2=2, B3, B4=3

Also 2) There is the possibility to have
B1 Aplle
B2 Orange
B3 NO
B4 Apple

In column A to count again the liines of COlumn B but not those that have
the "NO" and not duplicate in column B
So as a result again
A1=1
A2=2
A3
A4

Thanks in advance
Manos

 

[Max]

.. is it possible in column A to run a function which will count

automatically only the rows of column B that have input

In A2: =IF(B2="","",COUNTA(B$2:B2))
Copy down
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,000 Files:362 Subscribers:62
xdemechanik
---

 

[Max]

... to count again the lines of Column B

but not those that have the "NO"
and not duplicate in column B

In C2
=IF(B2="","",IF(SUMPRODUCT((B$2:B2<>"No")*(B$2:B2=B2))<>1,"",SUMPRODUCT((B$2:B2<>"No")*(B$2:B2=B2))))

In D2:
=IF(C2="","",COUNT(C$2:C2))
Select C22, copy down as far as required
Results that you seek will appear in col D
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,000 Files:362 Subscribers:62
xdemechanik
---

 

[Manos]

Sorry i am comfuse

I want to count the previous and if No just not to count.
the cell could be either empyt or no

 

[Max]

Think it works ok. Why don't you just try it out?
Separately, you asked 2 questions, and I gave you 2 suggestions
Empty cells are taken care of. These won't show up.
And do take a moment to press the "Yes" buttons (like the ones below).
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,000 Files:362 Subscribers:62
xdemechanik