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