 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 |
 |
 
|
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 felton316 If you are just generating a auto numbering sequen... Oct 18 2004, 01:49 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: 4th May 2025 - 08:38 PM |