Auto numbering

  • Thread starter Thread starter Manos
  • Start date Start date
M

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
 
... to count again the lines of Column B
but not those that have the "NO"
and not duplicate in column B
Click to expand...

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
---
 
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
 
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
 
Back
Top