Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]() Try this in B2 and copy down: =IF(AND(MAX(B$1:B1)=0,MIN(A1:A2)0,A2=A1+1),A1+A2, "") -- Cutter ------------------------------------------------------------------------ Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848 View this thread: http://www.excelforum.com/showthread...hreadid=472445 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Compare Negative & Positive Numbers | New Users to Excel | |||
Find Median of Positive numbers only in Range | Excel Worksheet Functions | |||
how do I rank negative and positive numbers? | Excel Worksheet Functions | |||
add only positive numbers and avg in a column | Excel Worksheet Functions | |||
How can I change positive numbers to negative, i.e. change 50 to - | Excel Discussion (Misc queries) |