LinkBack URL
About LinkBacks
Thank you, that worked!
Thank you, that worked!
Glad it helps you and thanks for the feedback and rep
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Marking this as unsolved for a moment as I have a follow-up question (if that's not allowed nevermind this and I apologize!)
I'm wondering if it would be possible to calculate streaks in the sheet, as in longest W or L streak? It would need to span rows from one day row to the next in case one day ended in 3 Ws and the next day began with 2, so a 5 W streak over 2 days.
Thanks for any help!
How many cells of data are there per row?
How many rows might be included in the streak? More than 2?
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
I made a quick screenshot of a part of the sheet:
\1
(In the screenshot I have a W at the end of the 26th, then 2 more to begin the 27th so that would be a 3 W streak.)
Hmmm...
Well, I'm not sure how to do this due to the possibility that many rows would need to be evaluated for a single count.
I guess it would be possible to have data like this:
Data Range
What results would you expect from that data?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks