| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to calculate gaps between events?
If there's a column with 100 "yes" or "no". I wanna calc the number of gaps
between each yes. For example: A1=yes A2=no A3=no A4=yes A5=no A6=yes Therefore, the output i wanna achieve is there is a maximum of 3 gaps between the yes and no (between A1 to A4) while the minimum gaps will be 2 (A4 to A6) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dates - gaps between | Excel Discussion (Misc queries) | |||
| Transpose Column With Gaps to Column With no gaps | Excel Discussion (Misc queries) | |||
| How can I calculate events that happened at the same time? | Excel Discussion (Misc queries) | |||
| Calculate % of events based on days worked | Excel Worksheet Functions | |||
| Transpose Column With Gaps to Row With No Gaps? | Excel Discussion (Misc queries) | |||
Threaded Mode
