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