How to display record of last 10 games

[dotcanada]

Good day.

I have been banging my head against the wall trying to figure this out. I've search past posts on this topic but still can't figure it out.
I've attached a sample of my spreadsheet of the schedule. What I would like to do is display the record of the last 10 games (W-L-OTL) for each team.

Thanks in advance.

NHL Schedule - Sample.xlsx

[Glenn Kennedy]

Still using Excel 2016?

[dotcanada]

Unfortunately, yes. Waiting for 2024 to come out later in the year.

[HansDouwe]

Plesase add manually the expected resuls of the formula to your sheet.

[Glenn Kennedy]

I fiddled with your sample, as no tema had more than 2 results. What do you mean by "their record". In the attached file what exactly would you like to see for the Carolina Hurricanes?

And >>>NO<<< I do not want a MASSIVE sheet, they're impossible to work with.

[dotcanada]

I've attached a sheet with more entries. I hope it's not too big. The original is over 1200 rows.

What I am trying to do is display a record of the last 10 games for every team. For simplicity's sake, let's choose just one team, the Carolina Hurricanes.
This sheet may not have 10 games from Carolina. So if it's 6 games, that's fine. I'm just trying to not give you a massive sheet as requested.

I want to be able to display the wins, losses, and OT losses (W-L-OTL) for the team in their last 10 games. So for example, (7-2-1)

My original spreadsheet (in which this sample came from) is massive so I'm hoping this sample has the info you need.

Thanks in advance.

NHL Schedule - Sample.xlsx

[Glenn Kennedy]

Please do as I asked. I will NOT be looking at 1200 rows.

[dotcanada]

I did. The attached has a few more entries. But like I said, it doesn't have 1200 rows.

[Glenn Kennedy]

I have been working on your original sample. Not one containing 200+ rows. I am not going to do any more until/unless you do as i asked.
Expected results, calculated manually for the sample file thst I attached. .

Otherwise,

Good luck... I'm out.

[dotcanada]

I have been working on your original sample. Not one containing 200+ rows. I am not going to do any more until/unless you do as i asked.
Expected results, calculated manually for the sample file thst I attached. .

Otherwise,

Good luck... I'm out.

Please be patient. It's been a long while since I've revisited this. I do respect your time.

NHL Schedule - Sample.xlsx

[Glenn Kennedy]

Thanks. I'm on my phone now. Gone out for dinner! Back later.

[AliGW]

Administrative Note:

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so. Cross-posts are allowed but you must provide a link to your posts on other sites.

Please see Forum Rule #7 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important: https://excelguru.ca/a-message-to-forum-cross-posters/

(Note: this requirement is not optional. No help to be offered until you provide a link or, for members with fewer than 10 posts, a comment telling us where else you have posted this query.)

[dotcanada]

Please delete this thread then.

[AliGW]

There is no need to delete this thread - yu just need to provide a link (or links) to the other forum (or forums) where you have asked the same question, as per our rules. Thanks.

[Glenn Kennedy]

So, I now have a solution for you. However, I am unable to post it UNTIL and UNLESS you provide the URLs for the crossposting(s) that you have made. if/when that's done, I will post the solution

[dotcanada]

https://www.mrexcel.com/board/thread.../#post-6154328

Problem solved.

[Glenn Kennedy]

And here, FWIW. I can explain, should you wish.