Auto Numbering #2

I would like to know if there is any method whereby an auto number can
be generated for me in the first column (A) for each record i enter ?

Example
1 ABC
2 ABCD
3 ...
4 ...
and so on


---
Message posted from http://www.ExcelForum.com/

0
1/1/2004 8:16:02 PM
excel 39879 articles. 2 followers. Follow

2 Replies
613 Views

Similar Articles

[PageSpeed] 24

One way
=if(b3<>"",a2+1,"")

-- 
Don Guillett
SalesAid Software
donaldb@281.com
"linuskmj" <linuskmj.zddja@excelforum-nospam.com> wrote in message
news:linuskmj.zddja@excelforum-nospam.com...
> I would like to know if there is any method whereby an auto number can
> be generated for me in the first column (A) for each record i enter ?
>
> Example
> 1 ABC
> 2 ABCD
> 3 ...
> 4 ...
> and so on
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>


0
Don
1/1/2004 8:49:17 PM
One method if entering data in column B......

=IF(B1<>"",1,"") entered in A1

=IF(B2<>"",A1+1,"") entered in A2 and copied down as far as you wish

Hang in.  I'm sure there will be more elegant methods suggested.

Gord Dibben Excel MVP


On Thu, 1 Jan 2004 14:16:02 -0600, linuskmj
<linuskmj.zddja@excelforum-nospam.com> wrote:

>I would like to know if there is any method whereby an auto number can
>be generated for me in the first column (A) for each record i enter ?
>
>Example
>1 ABC
>2 ABCD
>3 ...
>4 ...
>and so on
>
>
>---
>Message posted from http://www.ExcelForum.com/

0
Gord
1/1/2004 10:15:06 PM
Reply:

Similar Artilces:

Asks to insert Disk 2
Had Office 2000. Upgraded to XP. Can't open Publisher without inserting Disk 2 of 2000. Deleted, reinstalled, downloaded all updates and patches. Still won't open Publisher without inserting Disk 2. PUB2000 Error Message: The Feature You Are Trying to Use Is Not Available http://support.microsoft.com/default.aspx?scid=kb;en-us;218679 -- Mary Sauer MS MVP http://office.microsoft.com/clipart/ http://mvps.org/msauer/ "Glen" <GFGriffin@msn.com> wrote in message news:288401c3794e$4cdb3430$a601280a@phx.gbl... > Had Office 2000. Upgraded to XP. Can't open Pu...

Money auto-assign category to downloaded transactions
It's happened several times, but I can't quite pinpoint the trigger to it. Every now and then, when I download transactions into Money, it random assigns a category to all the transactions, and the category is the same one. For example, just earlier today, every transactions downloaded was assigned "automobile" as the category. I have tried different options under Tools - Setting - Online Sevices Setting, but I can't quite figure out how to prevent this from happening. Any idea? In microsoft.public.money, namsilat wrote: >It's happened several times, but I can&#...

Installing Money 2005 Deluxe #2
Can anyone tell me if I can install one copy of Money on my desktop and laptop? Microsoft seems to be keeping it a secret unless I pay $35.00 to ask a question! -- aantaug In microsoft.public.money, Anthony wrote: >Can anyone tell me if I can install one copy of Money on my desktop and laptop? >Microsoft seems to be keeping it a secret unless I pay $35.00 to ask a >question! Yes. That is permitted. Thank you, Cal. I've been all over Microsoft's Web site and couldn't find anything on that. I will purchase MS Money 2k5. By the way, I have been using the trial vers...

Auto Refresh on Opening
Created an Excel spreadsheet that runs an Access database query and loads the results into a cell. Problem - I want the data automatically refreshed (from Access)when I activate the spreadsheet in Excel. How/Where do I "code" for Excel to "refresh" before showing me the first worksheet. (Don't want to see a prompt - just want to get the latest data without having to click data refresh.) Thanks. Hi Sonya, > Created an Excel spreadsheet that runs an Access database > query and loads the results into a cell. > > Problem - I want the data automatica...

Suppressing auto format in Excel
I have a .CSV file that is automatically generated by a program. Apparently, when the file is opened with Excel, the numeric fields that are enclosed in double quotes in the file and look like "123,456.1234" are being formatted by Excel and displayed with only 2 decimals. The cause of the problem seems to be the comma in the number, which I don't really want to remove. Is there any way to suppress automatic cell formatting in Excel, so the contents could be displayed just the way it appears in the source file? In the Text import wizard - step 3 of 3 - select the offending colu...

MO reports serial number has already been created
I have a user who does Inventory transfers for serialized items. When a serial number he is looking for is not in the site it should be, he looks for it in some other ites. Once he's exhausted his search, he creates an MO for the item. When he's creating the MO, he tries to enter a serial number but GP reports that the serial number has already been used for this item. We can not find any instance where the serial number has been created. Has anyone seen this before? Any suggestions? Thanks. Jim ...

Set the serial number every 15th column
Hi All. I would like to set the serial number every 15th column. For example, A B C .................. 1 2 3 .. .. 15 1 .. .. 30 2 .. .. 45 3 Is there any formula for A column? Thanks in advance SJ In A1 and then copy down =IF(MOD(ROW(),15)<>0,"",ROW()/15) Copy Col A and paste special as values. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It'...

Convert number to text and add comma separator for thousands
I have a Text Box in a User Form that I am creating. The Text Box's value is set to a number without decimals. For example: Dim rents As Long rents = 4102 rentsTxtBox.Value = rents So when the number passes to the Text Box, I want it to display like this: 4,102. Basically, is there an vba function for excel that converts a number to a string and then adds the comma separator for thousands? If not what code would I use to do this? Thanks. rentsTxtBox.Value = Format(rents,"#,##0") -- --- HTH Bob (change the xxxx to gmail if mailing direct) "prahz" <ptho...

Information Store won't start after installing exchange (in child domain) #2
We are installing exchange 2003 in a child domain of a domain tree where an exchange 2003 server already exists in the parent domain. Netdiag and DCDiag were both performed before installation and indicated no problems with the general setup. The account used to install exchange has Full Exchange Administration rights at the org. level. The installation completes without any error messages, but it is impossible to start the information store. The store refuses to start and events 9153, 1121 and 5000 are then logged in the event log. Event 1121: Error 0x8004010f connecting to the Microsoft Ac...

How do I make 11.800 convert to 800 as a number not text
I want to drop the 11. and have the cell next to it be 800. I want to then be able to use that 800 and add other numbers to it. I am having two problems, 1) the 11.800 always becomes 11.8 ( I have tried increasing the decimals) and 2) if I have a different number like for example 11.255 by using RIGHT I succeed in getting 255 but as text. Please help. Thank you all in advance --- Message posted from http://www.ExcelForum.com/ Nave, =MOD(A2, 1) * 1000 will give you the 800 from 11.8 -- Earl Kiosterud mvpearl omitthisword at verizon period net -----------------------------------------...

Offline Address Book not updating #2
Hello, Our clients who used cached mode aren't getting an updated offline address book. We tried a rebuild but that didn't work- any suggestions. We are running Exchange 2003 SP2 on a Windows 2003 server. "Boe" <boe_d@notspam.hotmail.com> wrote: >Our clients who used cached mode aren't getting an updated offline address >book. We tried a rebuild but that didn't work- any suggestions. > >We are running Exchange 2003 SP2 on a Windows 2003 server. Check the Applications Log on the OAB server and make sure the OAB is being generated. There w...

Excel to XML #2
'Is there a converter for Microsoft Excel 2000 files that will save the files as .xml'. File, Save As the file extension is still .htm or .html -- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "MS" <msamant@drvc.org> wrote in message news:6d9a01c475a9$0dbed6f0$a501280a@phx.gbl... > 'Is there a converter for Microsoft Excel 2000 files that > will save the files as .xml'. ...

Data file did not close properly #2
I have read all kinds of solutions to this error. Has any thing difinitive been offered that solves the problem. Appreciated Jerry There isnt a difinative solution as the problem can be caused by a number of differing things "Jerry" <jerry@home.home> wrote in message news:eRfw6Cs1IHA.5300@TK2MSFTNGP06.phx.gbl... >I have read all kinds of solutions to this error. Has any thing difinitive >been offered that solves the problem. Appreciated > > Jerry > "Jerry" <jerry@home.home> wrote in message news:eRfw6Cs1IHA.5300@TK2MSFTNGP06.phx.gbl...

Auto notification about inactive account
Is there a way to notify an external sender that the email address they are trying to reach has been removed? We have already deleted the account and the default email goes to our administrators mailbox. Do I need to recreate the account and set some options up to automatically notify those senders Any help is greatly appreciated Thanks in advance John P.S. - Sorry if this shows up more than once. I posted it earlier, but didn't see it in the new postings for some reason. John C <anonymous@discussions.microsoft.com> wrote: >Is there a way to notify an external sender tha...

Mutual Fund Merger #2
I read the posting from Oct 03 and followed the suggestion. I completed the ratio as instructed. Problem is now I cannot change the investment name or symbol to that of the gaining fund because it is "already being used" by another account. Help please. I have Money 2004 Small Business. Oct 03 posting info is below _______ I have Money 2002 Deluxe & Bus. >>>I recently had 2 mutual funds merge and I cannot figure >>>out how to handle this in the Money program. It tells >>>about Company mergers and I read about 3 different ways >to >...

CRM Rollup 2 for Windows XP x64 client
Have been running CRM 3.0 on a Windows XP SP2 x64 client for a while without a problem, have to perform a repair in the install the other day and needed to apply the rollup 2 for the install, however when I attempt to perform the install it tells me it's for another hardware platform. Is there a version for x64 Windows XP I missed? Any help would be appreciated. ...

Excel drop down lists #2
Hi, I am trying to create two drop down lists. The first is a straight forward selection of 6 choices. I would like to be able to have a list in the next column which is dependent on the choice from the first list. For example from a choice of "A, B, C, D" in the first list, if i choose "A" I would like to have a drop down list choice of "9, 8, 7" in the second column. But if i choose "C" in the first list, then I would like to have a drop down list choice of "6, 5, 4" in the second column. Is this possible? And if so, could you please tel...

Auto Accept Agent Double Booking Support
Hello, Is it possible to configure the Auto Accept Agent to support double booking? We have some resources that need to allow that. Thank You. ...

Number of Observations
I have a column (say Column A) with 300 values (basically it is a DDE link with data I update). I also have a cell I would like to use (say B1). In cell B1 I would like to be able to enter a value (say 20) where I will be able to use this value in another cell to "observe" the top 20 of the cell from column A. So, If I put 20 in cell B1, in cell (say C1) I would like to put some formula where it can reference the "how many observation" cell B1, and say sum A1:AXX where xx is the value in cell B1. I know in this form it cannot be done, but was wondering if someone ...

Preventing auto-formatting when Replacing
Say I have a cell that contains LED2/14 The cell is formatted as Text. If I use Ctrl-H to replace LED with nothing, Excel insists on reformatting the remaining 2/14 as a date (i.e. 14-Feb). Is there any way to prevent this infuriating behavior? Thanks, Frank How about: Edit|Replace LED with ' (apostrophe) Frank Marousek wrote: > > Say I have a cell that contains > > LED2/14 > > The cell is formatted as Text. > > If I use Ctrl-H to replace LED with nothing, Excel insists on reformatting > the remaining 2/14 as a date (i.e. 14-Feb). Is there any way to...

Multiple Taxes (i.e. 2 Diff States)
RMS V1.3flat I am trying to establish two different Item tax structures for two different tax authorities, let's say one for MN and one for ND state. Preface: I am giving this as a real HL example. Assigning taxes on a per customer basis will not work as a solution to this issue. Please do not take it literally that I need to assign per customer based on Billing or Shipping State. Example: MN Tax has: MN State, MN City and MN County ND Tax has: ND State and ND County I have created all tax authorities in Sales Tax, and then bundled appropriately in Item Tax (one item tax = MN St...

How can you identify folders, using folder numbers?
Hi everybody, I've searched and searched and asked in the quasi-defunct yahoo exchange newsgroup, but I've never found an answer as to how I can actually utilize the folder identification information contained in Exchange error log events. An example is as such: Event: 1173 Source: MSExchangeIS Mailbox Store Description: Error 0x6bb deleting unused restricted view from folder 1-1A42FF on database "First Storage Group\SG1 Mailbox1". It would be insanely useful if I could tell which folder 1-1A42FF is, so I can narrow down where the problem is occurring, you know?? Anyone...

Sort combination of letters and numbers
I have this type of data to sort: C-1, C-2, C-3, C-4, C-5, C-6, all the way up to C-500, but it doesn't sort into number order. How can I make it sort by number, and disregard the "C-" part? thanks! Assuming your data is in column C and it starts in row 1... In a blank column next to your data enter this formula... =RIGHT(C1,LEN(C1)-2) Fill the formula down to the bottom of your data. Select both columns and sort using the new column as the key. -- Jim Cone Portland, Oregon USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins - try the "Special So...

SVG problems in Visio 2003 SP 2
Hi! I tried to create a new document (metrics format) and added a few different shapes (also metric). I saved the document in SVG format and closed the document. I then tried to open the document again, but got a lot of errors, and some of my shapes could be located at the lower left corner, but a bit misshaped. Also when opening the document i IE it is incorrect. (I detected this behavior with a mush more complex drawing, and that was totally messed up after saved as SVG.) Is this a known error, or is there something wrong with my local setup? Best Regards, Andreas Lundgren Log file: Op...

outlook contacts #2
When I try to access my contacts in outlook 2000, via the toolbar or menu it immediately shuts down outlook. Could anybody clear up what I have done to cause this. I tried re-installing it and running the repair to no effect. Please help This is very annoying. find and rename outcmd.dat and restart outlook. Does it fix it? -- "Dan" <dan_ryan@iolfree.ie> wrote in message news:089801c35658$5833dad0$a301280a@phx.gbl... > When I try to access my contacts in outlook 2000, via the > toolbar or menu it immediately shuts down outlook. > Could anybody clear up what I hav...