| 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 | |
|
|
Similar Threads
|
||||
| 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) | |||
Hybrid Mode
