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.