numbering

Currently In column A I have the heading item number, and beside it in column B is the description (for example bonds). There are two things I want to accomplish. 1. I want to have the numbers automatically appear when the adjacent cell is occupied, so I used the formula...

I need column A to sequentially number...not so hard until I throw in that the number is hyphenated and only the first part needs to sequence. I've searched until my eyes fell out and rolled onto the floor. Please help! ex: 0001-2014 0002-2014 0003-2014 0004-2014

I apologize if this has been covered. I did quite a bit of research, but wasn't able to find anything that helped me (maybe I was using the wrong terminology). I have a very large spreadsheet with a list of clients with several sub categories for each client. I need 2 formulas (preferably, no...

Say I am trying to create a bill of materials list that generates, sorts and numbers according to pushbutton clicks after the user selects the vlookup values provided in a data set list of a drop down menu. After I have randomly created these values I can add them to the bill, then sort them...

Greetings all- I've been sorting through all kinds of message boards and other help sites in search of an answer. I have 2 worksheets representing a left page and a right page of a logbook. They are on separate worksheets because they have different column & row dimensions and I was unable to...

In cell A1 if have a number 9921 i would like to know which formula i should use to extract the non duplicate digits in the number. the number would display in 2 in b1 and 1 in b2 sometime the number might have 3 duplicate digits example: 9991 but if the number has 2 sets of duplicate digits...

Hi all,Please see below, I need help with a formula or code for column A, I would like it to auto number depending on category chosen, For example if J2 was selected next the serial would be J2-003 because there are three J2 entries. A B C D. Serial J Category Task. J1-001 J1 EXAMPLE EXAMPLE...

Hi All, Scratching my head trying to sort a large file based on a column of decimal style numbers that has been exported from another application. I am on Win 7 running Excel 2010 Numbering sequence should be: 1, 1.1, 1.2, 1.3, 1.4, 1.5, 1.6, 1.7, 1.8, 1.9, 1.11, 1.12 but I have it all...

I hope someone can help the cells on the left are green amber and green if they r they green the cell on the right will auto put a 2 in the cell if its amber it puts a 1 and red a 0. Thank you

Hi I work in an IT department and have been asked a question about an Excel sheet - they have a sheet with numbered rows (1, 2, 3, etc) but with several rows for heading and title information the first numbered row is row 5. They have to keep working on this sheet, sometimes adding or...

Hi, After combining several Word documents into one master document using VBA from Excel, I find that some of them automatically restart the page numbering that I have in the master document footer. The master document is created using a template that has a footer showing the page numbers. Is...

Hi to all, I got problem.Initially my excel sheet looks like this. Excel WorkbookAE9181PALLETIZING STOPPER-2 CYLINDER DOWN9282PALLETIZING STOPPER-3 CYLINDER UP9383PALLETIZING STOPPER-3 CYLINDER DOWN94DESTACKER9584STACK HOLDING CYLINDER-1 - EXTENDED9685STACK HOLDING CYLINDER-1 -...

I have created a form that when printed will be used as a rejection tag for isolating damaged or on-hold parts. Each tag that is printed must have a unique ID number. Is there a way to have excel automatically populate a field, giving each saved/printed tag a unique ID? For example, I open...

Hey all is there a quick and easy way of numbering duplicates in a list? Sort of in the same way that Windows chucks a (1) or a (2) on the end of files with the same name? I have this list (and lists like it in the future) in my table MPR25CS MPR25CE MPR25CS MPR25CS MPR25CE MPR26CS MPR26CS...

Hello, I have a spreadsheet where I keep track of information for a bi-weekly payroll system. Most years there are 26 pay periods in the year. I want to have the pay period number reset the suffix to "01" when it reaches 26. I also would like it to switch the prefix to the next year. Here...

Excel 2008 - Windows XP I am trying to get sequential numbers in column B based off values in column A. Here is an example of what I would like to see in column B. <table style="border-collapse: collapse; width: 102pt;" width="136" border="0" cellpadding="0" cellspacing="0"><col style="width...