I have a title row containing the name of a test that I am running. Each row under that will be numbered for different test senarios. I would like to have each row contain the test name and then a consecutive number such as:
Test name: Ball
Ball - 1
Ball - 2
Ball - 3
Is there a way to have excel pull the name of the test from a cell and put a consecutive number with it down the rows as I go automatically?