Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
hi, in Column M i have a list of results that will go on down the page as
values are entered elsewhere, these results will be both negative and positive, i was after a formula that will give me the count of the current run of positive numbers, eg. below, the cell with the formula in it would return a value of 4 for the current run of positive numbers, and if there was a run of negative numbers it would be 0 2 5 6 -5 2 4 7 9 -- thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel change a group of positive numbers to negitive numbers | Excel Discussion (Misc queries) | |||
Excel, change column of negative numbers to positive numbers? | New Users to Excel | |||
Count cells with positive numbers | Excel Discussion (Misc queries) | |||
How do I count how many positive and negative numbers in a couumn | Excel Discussion (Misc queries) | |||
convert negative numbers to positive numbers and vice versa | Excel Worksheet Functions |