Hi guys,

imagine the game Rock-Paper-Scissors in Excel. I have an Excel sheet with rows in which I write down the things my opponent chose. For example:

Row1: 1 (for rock)
Row2: 3 (for scissors)
Row3: 2 (for paper)

and so on...

Now I'd like to write something like a sequence in the past matching the last few moves. For example, if in the last two moves we played paper against rock and scissors against rock, I'd like to look for times in the past when the same two moves occurred. It would be great to have something like the last two moves, the last three moves, the last five moves and maybe also the last ten moves - only if it's not that difficult to write...

Can anyone help me with that?

Thank you guys so much!

Josh