If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
automatic numbering of rows in excel, how to?
How can I set up the first column to automatically number each row as I go
down a list in excel? Office 2000 |
#2
|
|||
|
|||
Assuming the data will be entered in column B starting in B1 and the data
are numbers. Put this in cell A1 and copy down. =IF(ISNUMBER(B1),ROW(),"") If data are text then substatute ISTEXT for ISNUMBER Don Pistulka "Linda C." Linda wrote in message ... How can I set up the first column to automatically number each row as I go down a list in excel? Office 2000 |
#3
|
|||
|
|||
automatic numbering of rows in excel, how to?
This works great, but what if the data can be either numbers or text?
Example: 5444 5445 5446 AXC XSLR AXC XLLR "Don" wrote: Assuming the data will be entered in column B starting in B1 and the data are numbers. Put this in cell A1 and copy down. =IF(ISNUMBER(B1),ROW(),"") If data are text then substatute ISTEXT for ISNUMBER Don Pistulka "Linda C." Linda wrote in message ... How can I set up the first column to automatically number each row as I go down a list in excel? Office 2000 |
#4
|
|||
|
|||
automatic numbering of rows in excel, how to?
What I need
excel to do, is to insert numerical numbering into the cells starting at A19, the formula in B15 multiples B9, B10 and B13, so whatever is the sum of B15, I need Excel to start inserting numbers numerically at cell A19 to whatever the sum of B15 is, so if B15 is 30, I need 1 thur 30 inserted starting at A19 thru A49. Thanks MJS "Don" wrote: Assuming the data will be entered in column B starting in B1 and the data are numbers. Put this in cell A1 and copy down. =IF(ISNUMBER(B1),ROW(),"") If data are text then substatute ISTEXT for ISNUMBER Don Pistulka "Linda C." Linda wrote in message ... How can I set up the first column to automatically number each row as I go down a list in excel? Office 2000 |
#5
|
|||
|
|||
automatic numbering of rows in excel, how to?
Put in:
A19: 1 A20: =IF(A19+1B15,"",A19+1) Copy to A21 and down as far as you will ever need to go. You may want to alter your print settings after this so it doesn't print the blank cells. |
#6
|
|||
|
|||
automatic numbering of rows in excel, how to?
On Sep 3, 10:19 am, Spiky wrote:
Put in: A19: 1 A20: =IF(A19+1B15,"",A19+1) Copy to A21 and down as far as you will ever need to go. You may want to alter your print settings after this so it doesn't print the blank cells. Oops. One change: A20: =IF(A19+1$B$15,"",A19+1) |
#7
|
|||
|
|||
automatic numbering of rows in excel, how to?
Thanks Spiky, it works just fine...
"Spiky" wrote: On Sep 3, 10:19 am, Spiky wrote: Put in: A19: 1 A20: =IF(A19+1B15,"",A19+1) Copy to A21 and down as far as you will ever need to go. You may want to alter your print settings after this so it doesn't print the blank cells. Oops. One change: A20: =IF(A19+1$B$15,"",A19+1) |
#8
|
|||
|
|||
automatic numbering of rows in excel, how to?
Hi I'm using excel 2007 ..
I read this topic but FOR text it is not working =IF(ISTEXT(B1),ROW(),"") but for numbers it is working =IF(ISNUMBER(B1),ROW(),"") is there anything different for 2007 |
#9
|
|||
|
|||
automatic numbering of rows in excel, how to?
It certainly works for me, once can of course change it to either text or
numbers =IF(LEN(B1)0,ROW(),"") -- Regards, Peo Sjoblom "Robi" wrote in message ... Hi I'm using excel 2007 .. I read this topic but FOR text it is not working =IF(ISTEXT(B1),ROW(),"") but for numbers it is working =IF(ISNUMBER(B1),ROW(),"") is there anything different for 2007 |
#10
|
|||
|
|||
automatic numbering of rows in excel, how to?
Thank you Peo Sjoblm
every code is working for me.. =IF(LEN(B1)0,ROW(),"") can help me to say how to add auto number of rows by selecting some rows which I need to number.. I've 6000 rows.. But they will be numbered by selecting 200 rows or 300 rows. After 200 they will be counted or number from 1. Is there any way cell selection with mouse and number them? "Peo Sjoblom" wrote: It certainly works for me, once can of course change it to either text or numbers =IF(LEN(B1)0,ROW(),"") -- Regards, Peo Sjoblom "Robi" wrote in message ... Hi I'm using excel 2007 .. I read this topic but FOR text it is not working =IF(ISTEXT(B1),ROW(),"") but for numbers it is working =IF(ISNUMBER(B1),ROW(),"") is there anything different for 2007 |
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I find duplicate rows in a list in Excel, and not delete it | Matthew in FL | General Discussion | 2 | June 15th, 2005 09:11 PM |
Excel Range Value issue (Excel 97 Vs Excel 2003) | Keeno | General Discussion | 2 | June 13th, 2005 02:01 PM |
Can Excel "slide up" rows with content thru empty rows to condense | portly44 | Worksheet Functions | 2 | April 1st, 2005 12:47 AM |
Automatic Links in Excel 2003 | Bernie | Links and Linking | 0 | December 16th, 2003 02:16 PM |
Automatic links shows up as a #Value# error in EXCEL XP but not in EXCEL 2000 | [email protected] | Worksheet Functions | 1 | November 10th, 2003 03:19 AM |