Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
consecutive
Is it possible for Excel to look at a column of results, and determine
the number of times I had consecutive winning or losing streaks from my stock speculation? My column of data either has a PLUS figure, a MINUS figure, or more times than not, a blank "" result, representing no trading. For example, the "x" represents the rusults I need: Consec. W/L Win Frequency Loss Frequency 1 x x 2 x x 3 x x 4 5 etc. Thanks again, Erick |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
counting consecutive absences | Excel Worksheet Functions | |||
Return Summed Count of Multiple Consecutive Numeric Values | Excel Worksheet Functions | |||
Count Intervals of 2 Consecutive Values in same Row and Return Count across Row | Excel Worksheet Functions | |||
adding three consecutive columns | Excel Worksheet Functions | |||
Return Consecutive Values - Pairs | Excel Worksheet Functions |