Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a series of rows that show W's (wins) and L's (Losses) from baseball
tournaments. Example: W W L L W W W L W W L What formula can I use to count from the bottom up, counting only the most recent W's near the bottom, ending the count at the first L to show the most recent winning streak (in this case, it would show "2"). Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Counting rows | Excel Worksheet Functions | |||
Counting rows??? | Excel Discussion (Misc queries) | |||
Counting characters in multiple rows when rows meet specific criteria | Excel Worksheet Functions | |||
Counting Rows | Excel Discussion (Misc queries) | |||
Counting rows, then counting values. | Excel Discussion (Misc queries) |