Some questions for my League of Legends Statistics spreadsheet

So I'm a nerd and have gotten into the game League of Legends. The problem is that I'm a HYPER nerd and want to track my statistics, too. I started this in Word but figured it would be much more efficient if I made an Excel spreadsheet, but I'm only familiar with some basic things. I was hoping to get some help formatting this spreadsheet so that it will shine out amid my uber nerd lifestyle.

My CURRENT question is this:

excel_002.jpg

I want it so that when I add a new name to column B (in this case it would be in cell B43), it will automatically add the next number to the left of it (in this case, 041) into cell A43. Is this possible?


Thanks so far to ChemistB who's helped me out in this silly project of mine.

Sounds like
COUNTA($C:$C) will give you total games
=COUNTIF($C:$C, "Win") to give wins

Is that what you needed?

Sure,
Assuming you are formatting Column A with Custom number format 000
In A4 copied down as far as you think you will go
=IF(ISTEXT(A4), A3+1, "")
Does that work for you?

It is giving you an error (my guess) because the value in A3 is stored as text.
Select Column A
Right click > Format Cells
Number tab> Custom Format
Replace "General" with 000

Then paste that formula into A4 (where you had 002) and drag it down.
Questions?

It looks like your "numbers" in A may be text, not actual numbers/values. Test with =isnumber(A42) (or any of them) FALSE indicates that your number is actually text that looks like a number. You cant add a value to a number (How much is phone +5? lol)

Do the numbers have to be 3-digit? if not, renumber them all, Atart with 1 in, say, A2, then use this in A3 (or the next cell down, just adjust the ref) =if(B3="","",A2+1) copied down

OK then maybe they have a custom format to make them appear that way. Can you upload a sample of you workbook please?

Upload an example of your sheet (Go Advanced> Manage Attachments). Hard to diagnose what is wrong without looking at it.