Hi, first post so hopefully I don't sound like too much of a novice!
I want to have certain rows with a character reference running from A-Z
However I only want it to have a reference if there is data on that row.
For example if cell B1 has data then I want A1 to say "A"
If the next row holds no data I want to skip that row.
If B3 has data then A3 would read "B" and so on.
I have tried messing around with =CHAR(CODE(A1)+1) but it only works when it's for every row
Is there a way to say =IF B1 <>"" then A1 = CHARACTER FROM LAST FILLED CELL+1
Hopeful that makes sense to somebody.
I want to have certain rows with a character reference running from A-Z
However I only want it to have a reference if there is data on that row.
For example if cell B1 has data then I want A1 to say "A"
If the next row holds no data I want to skip that row.
If B3 has data then A3 would read "B" and so on.
I have tried messing around with =CHAR(CODE(A1)+1) but it only works when it's for every row
Is there a way to say =IF B1 <>"" then A1 = CHARACTER FROM LAST FILLED CELL+1
Hopeful that makes sense to somebody.