 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, 03:44 PM
Post
#2
|
|
|
Senior Member Group: Advanced Members Posts: 5,226 Joined: 24-December 03 From: Danville, CA, USA Member No.: 27 |
QUOTE (mitchntx @ Oct 17 2004, 09:29 PM) I am convinced that is I wanted to know how a black hole exists, the meaning of life or how it is the geekiest looking guy can be with the hottest woman (went to the IRL race today and personally witnessed this freak of nature), someone here could tell me. THAT....is simple.... $$$$$$$$$$$$$$ (IMG:http://www.frrax.com/rrforum/style_emoticons/default/laugh.gif) |
|
|
|
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
 |
2 User(s) are reading this topic (2 Guests and 0 Anonymous Users)
0 Members:
| Lo-Fi Version | Time is now: 5th May 2025 - 12:07 AM |