Upon search I have found https://www.mrexcel.com/forum/excel...ting-current-streak-record-last-10-games.html but I cannot get it to work like it is written. Upon edited many time all I could ever get it to do was show 10W all the time.
I too have a sheet (Sheet1) with a column of names for winners (Column B) and a column for losers (Column C). The latest games are put at the bottom of the list. On a separate sheet (Sheet2) I have a list of all players in column B. On Sheet2 I want to show the number of wins in the players last 10 games.
Any help?
I too have a sheet (Sheet1) with a column of names for winners (Column B) and a column for losers (Column C). The latest games are put at the bottom of the list. On a separate sheet (Sheet2) I have a list of all players in column B. On Sheet2 I want to show the number of wins in the players last 10 games.
Any help?
