Hi guys, just wondering if anyone could please help me.
Column A stores player names, Column B stores the players score for that game.
A players name will appear numerous times in column A, as each different match will be posted, with his score for that match located in column B.
I would like to count the number of times each player scores between a certain range, in this situation between 50 and 100. Preferably I would like to use excel formulae, rather than VBA for this task.
I have attached a sample data sheet, which should show what I mean more clearly.
Cell D3 should represent the number of times "Beck" scored between 50 & 100
Cell E3 should represent the number of times "Beck" scored in excess of 100
Cell F3 should represent the highest score of "Beck"
I hope I have explained this ok.
Thanks in advance.