Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
again: number a list
Hello there!
I found a thread "number a list" (June 2nd.2006): I have an excel ss of book and video titles. I would like to make one column the number corresponding to each title. Just a simple scheme like 1, 2, 3, 4, 5, etc... How would I tell excel to put sequential numbers in a column? The problem was solved easy. But what can I do when I have empty rows? I entered free rows for better looking print result, unfortunately BEFORE fillseries. Is there a formula, something like IF B10 fill A1? Thanks for help! Mike |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
again: number a list
Mike, have a look here and see if this will do what you want,
http://www.j-walk.com/ss/excel/usertips/tip035.htm -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Mike Sound" wrote in message ... Hello there! I found a thread "number a list" (June 2nd.2006): I have an excel ss of book and video titles. I would like to make one column the number corresponding to each title. Just a simple scheme like 1, 2, 3, 4, 5, etc... How would I tell excel to put sequential numbers in a column? The problem was solved easy. But what can I do when I have empty rows? I entered free rows for better looking print result, unfortunately BEFORE fillseries. Is there a formula, something like IF B10 fill A1? Thanks for help! Mike |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
again: number a list
You could delete the blank rows, then do the fill on the number column, then
re-insert the blank rows. ASAP Utilities has features to expedite these actions. Available free at www.asap-utilities.com Vaya con Dios, Chuck, CABGx3 "Mike Sound" wrote in message ... Hello there! I found a thread "number a list" (June 2nd.2006): I have an excel ss of book and video titles. I would like to make one column the number corresponding to each title. Just a simple scheme like 1, 2, 3, 4, 5, etc... How would I tell excel to put sequential numbers in a column? The problem was solved easy. But what can I do when I have empty rows? I entered free rows for better looking print result, unfortunately BEFORE fillseries. Is there a formula, something like IF B10 fill A1? Thanks for help! Mike |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
again: number a list
I would delete the blank rows and just make the data rows double-height for the
"better print result" Then go with the fill series to generate the numbered rows. Gord Dibben MS Excel MVP On Sun, 18 Jun 2006 13:46:27 -0400, "CLR" wrote: You could delete the blank rows, then do the fill on the number column, then re-insert the blank rows. ASAP Utilities has features to expedite these actions. Available free at www.asap-utilities.com Vaya con Dios, Chuck, CABGx3 "Mike Sound" wrote in message ... Hello there! I found a thread "number a list" (June 2nd.2006): I have an excel ss of book and video titles. I would like to make one column the number corresponding to each title. Just a simple scheme like 1, 2, 3, 4, 5, etc... How would I tell excel to put sequential numbers in a column? The problem was solved easy. But what can I do when I have empty rows? I entered free rows for better looking print result, unfortunately BEFORE fillseries. Is there a formula, something like IF B10 fill A1? Thanks for help! Mike |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
again: number a list
"Paul B" schrieb im Newsbeitrag
... Mike, have a look here and see if this will do what you want, http://www.j-walk.com/ss/excel/usertips/tip035.htm Yes, Paul, that's exacly what I need! But poor Mikey is too stupid to translate the formula for the german Excel 2002. I tried a lot with ZÄHLE (for COUNT), but it will take time to get it fixed and working. The other tips were also good, but I am a little obstinate and a formula is more elegant. Thanks all! Mike |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
again: number a list
Mike, hope it works out for you, I can't help with the German
-- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Mike Sound" wrote in message ... "Paul B" schrieb im Newsbeitrag ... Mike, have a look here and see if this will do what you want, http://www.j-walk.com/ss/excel/usertips/tip035.htm Yes, Paul, that's exacly what I need! But poor Mikey is too stupid to translate the formula for the german Excel 2002. I tried a lot with ZÄHLE (for COUNT), but it will take time to get it fixed and working. The other tips were also good, but I am a little obstinate and a formula is more elegant. Thanks all! Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I count the number of repeats in a list of data? | Excel Discussion (Misc queries) | |||
how to get the number of unique records in a list | Excel Worksheet Functions | |||
Select every 10th number in a list | Excel Discussion (Misc queries) | |||
change info in other cells when i change a number in a drop list? | Excel Discussion (Misc queries) | |||
Lookup in a list of number with a headline | Excel Discussion (Misc queries) |