To simplify this question for the sake of getting the help necessary, if I have 2 columns of 10 cells each in Excel and I wanted to place numbers from 1 to 10 in the right column based on when the columns to the left have text placed in them, how would I do that?
So let's say my cell range is A1:B10. If someone put any word, say "Mike", in cell A4, then cell B4 would populate with a 1. If they next put "Bill" in A10, then cell B10 would populate with a 2. The numbers in the right column would continue to increment until I have 10 cells numbered 1 through 10.
Any suggestions? Thanks in advance!