Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Generating auto Number
Hi There,
I am new to this. I have one problem. I have a workorder sheet, and I want the work order to be numbered, so everytime I make new workorder, a number will be added. How do I do that? any idea? -- nandu |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Generating auto Number
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html
-- Gary''s Student - gsnu200805 "Nandu" wrote: Hi There, I am new to this. I have one problem. I have a workorder sheet, and I want the work order to be numbered, so everytime I make new workorder, a number will be added. How do I do that? any idea? -- nandu |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Generating auto Number
In addition to what Gary's student responded, you could also add a
helper column with this formula: =IF(NOT(ISBLANK(B1)),ROW(),"") For example if your data was in column B, starting in B1, put this formula in an adjacent column and fill it down as needed. As you add data to column B, the numbers will fill in. Of course, you won't be able to sort the data, because the numbers will change, unless you copy and paste the formula values first, then reinsert the formula after you're done. --JP On Sep 19, 12:56*pm, Nandu wrote: Hi There, I am new to this. *I have one problem. *I have a workorder sheet, and I want the work order to be numbered, so everytime I make new workorder, a number will be added. *How do I do that? *any idea? -- nandu |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto generating number | Excel Discussion (Misc queries) | |||
Generating an auto number | Excel Worksheet Functions | |||
Auto-generating a list of records that meet a pattern criteria | Excel Discussion (Misc queries) | |||
Auto generating a printed date | New Users to Excel | |||
Generating (in a random order)each number once from a given number | Excel Worksheet Functions |