Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 --- |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 --- |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 --- |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Numbering | Excel Discussion (Misc queries) | |||
auto numbering | Excel Discussion (Misc queries) | |||
Auto Numbering | New Users to Excel | |||
Auto Numbering | Excel Discussion (Misc queries) | |||
auto numbering | Excel Discussion (Misc queries) |