Hi rylo,

Thanks for that, worked perfectly. You were correct, my sheet was called Results, apologies for not specifying this.

As it happens, I had put together a workaround using 2 While statements to count each cell 1 by 1, which took twice as much code and would take a lot longer with more values.

Thank you again, this was a good excercise for teaching me how to write Range formulas.

-Bob