 Who's good with MS-Excel? |
|
|||||||||
 Oct 17 2004, 04:44 AM
Post
#1
|
|
|
Experienced Member  Group: Advanced Members Posts: 1,086 Joined: 16-January 04 From: Chandler AZ Member No.: 130  |
need a formula written, have been searching through the MS-help and can't seem to find a way to write the formula I want. I need a formula that shows the next number in column A when I enter data in column B.
For instance, if A2 says "1," then when I click on B3, I want A3 to show "2." I also need the number to show in five digits, e.g., 00001, 00002, etc. Where's the enguhneers out there??? (IMG:http://www.frrax.com/rrforum/style_emoticons/default/smile.gif) Rob |
 |
 
|
 |
Replies
|
Oct 18 2004, 01:49 AM
Post
#2
|
|
|
Member Group: Advanced Members Posts: 179 Joined: 28-December 03 From: Texas Member No.: 56 |
If you are just generating a auto numbering sequence for column A:
=IF(B1<>"",COUNTA($B$1:B1)&".","") Paste that into A2, then copy it into all cells in the row that you want to auto number. Every time a entry is made into column B it will number column A. If you were to delete the info im column B Cell 50 out of 100 Cells, it will automaticly renumber Column A. Now to format to 5 digits, I have no clue....... I'll have to play around with that one. |
|
|
|
Posts in this topic
Rob Hood Who's good with MS-Excel? Oct 17 2004, 04:44 AM
RedHardSupra First part is either trivial or I'm not gettin... Oct 17 2004, 07:55 AM mitchntx =(cell number)+1
in the target cell should get it... Oct 17 2004, 09:39 AM Jeff94TA QUOTE (mitchntx @ Oct 17 2004, 04:39 AM)For t... Oct 17 2004, 05:36 PM Rob Hood ok, I'm getting there - thanks for all the inp... Oct 17 2004, 09:27 PM y5e06 edited to add if statement (always check your work... Oct 18 2004, 12:40 AM Rob Hood Morgan, thanks for the input. I did try your sugg... Oct 18 2004, 01:20 AM mitchntx OK ... now I'm curious ...
What the hell are ... Oct 18 2004, 01:24 AM Rob Hood pretty much banging my head like that emoticon...
... Oct 18 2004, 01:43 AM mitchntx I am convinced that is I wanted to know how a blac... Oct 18 2004, 03:29 AM trackbird QUOTE (mitchntx @ Oct 17 2004, 10:29 PM)I am ... Oct 18 2004, 03:51 AM
rmackintosh QUOTE (mitchntx @ Oct 17 2004, 09:29 PM)I am ... Oct 18 2004, 03:44 PM |
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:
| Lo-Fi Version | Time is now: 5th May 2025 - 12:14 AM |