Cell auto numbering - is this possible?
I'd like for a column of cells to be able to number themselves whenever something is entered in the column next to it.
For instance, in Column A I have cells numbered 001, 002, 003, in A1, A2, A3, etc
I'd like it so when I enter text into a cell in Column B, for instance B4, that Column A will automatically number the next in the series, for instance putting 004 in A4.
Is this possible?
If you first input a serial no. manually in A1, try this in A2 and copy down as far as needed.
A2 =IF(B2="","",A1+1)
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Hmm, I'm entering that formula exactly but nothing is happening in the cell when I hit enter. :\
If you are entering that formula in A2 and B2 has no value, you won't see the serial no. in A2 and once you enter a value in B2, the next serial no. will populate in A2.
Make sure you have manually entered a serial no. in A1 as well.
If you put something in Column B, just put this formula in column A and copied down
=IF(B1<>"",TEXT(ROWS($B$1:B1),"000"),"")
Azumi
Doubled Post
Last edited by azumi; 12-15-2013 at 05:57 AM.
Great! Works like a charm, azumi! Thanks so much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks