IPB

Welcome Guest ( Log In | Register )

 Forum Rules 
Unbalanced EngineeringSolo PerformanceHotpart.comBlaine Fabrication.comUMI Performance
> Who's good with MS-Excel?
Rob Hood
post 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
Go to the top of the page
 
+Quote Post
 
Start new topic
Replies
trackbird
post Oct 18 2004, 03:51 AM
Post #2


FRRAX Owner/Admin
********

Group: Admin
Posts: 15,432
Joined: 13-February 04
From: Ohio
Member No.: 196



QUOTE (mitchntx @ Oct 17 2004, 10: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.

Yea, and I think I may need to create a new forum for those questions (IMG:http://www.frrax.com/rrforum/style_emoticons/default/rotf.gif) .

I'm just not sure what to call it......

Can we get Stephen Hawking for a moderator?


And remember Mitch:

When a great looking guy is with an ugly woman. That's love.

When a great looking woman is with an ugly guy. That's money.

When two ugly people are together. That's just the way it works.

(I take no credit or blame for the above "wisdom").
Go to the top of the page
 
+Quote Post

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

« Next Oldest · General Discussion · Next Newest »
 

Reply to this topicStart new topic
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:18 AM