Auto numbering
 

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

Auto numbering
 

.. 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
---

Auto numbering
 

... 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 C2:D2, 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
---

Auto numbering
 

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" wrote:

... 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 C2:D2, 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
---

Auto numbering
 

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
---
"Manos" wrote:
Sorry i am confuse

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