I am having some issues with a dataset that came from an outdated system our business used before I joined, they had recently moved to a new system when I joined and now I can see why!
The data below relates to Customer Journeys, which lack a vehicle identifiable field (which...
I'm trying to make a list of codes based on a format of 001 A 001. They should be 001 to 062, A to E, 001 to 012. I need all combinations, so they would be:
001 A 001
001 A 002 to
001 A 012, then up to 001 E 012
Then 001 B 001 to 012, and so on until 001 E 001 to 012
Then 002, A to E, 001 to...
Is it possible to have a cell populate an alpha numeric sequence based on the selection from a data validation list?
For example I was hoping to be able achieve - if someone selects “Design” from the drop down, this would cause the next cell to populate “DR134” and so on sequentially...
I am creating a user form in which there are going to be 30+ textboxes. After copy pasting a few in, deleting a few, then adding more in, the numbering of these boxes are all over the place. I am doing a routine to populate these textboxes with values from a sheet within the workbook. I am...
I have column A containing positive and negative numbers and I am looking for a formula in column B for sequential numbering as follows
col A col B
I'm having a massive problem getting an auto filling sequential number down a list of rows (column A). If one box has a value greater than 0 (column G)then I want to input a number (starting at 1). If one or several rows don't have this input I need that cell left blank, but need to keep the...
I was looking for a way of moving sequential numbers from Column A to Column B. I.E. If column A had numbers 1,3,6,8,9,10,11,12,15,17,19,20,21,24,28
Then numbers 9,10,11,12 and numbers 19,20,21 would be moved to the respective cell to the right in Column B?
I need to make make columns auto number in a certain order. Maybe someone can help
Can it be done?
Thanks for any help
I am attempting to do the following and would appreciate any help:
I have a spreadsheet that looks like the following
I manually enter in the information in the first column. In the second column, I...
how to make sequential number with parameter
my target in column "interval" and "given" number as parameter (based on)
like this layout :
border: 1px solid #CCC ;
I have a worksheet that I created that is a blank purchase order for my organization.
Someone prints multiple copies of the purchase order worksheet. Then the person has to write in a sequential number on each purchase order.
Is there a way to have Excel number each purchase order?
I have created a form in excel with invoice number which is alpha numeric.
im having a hard time fixing the error about the leading zeros in my invoice number. My invoice number is FIN19-0001.
i want to change it from FIN19-0001 to FIN19-0002, FIN19-0003 and so on.
but every time i click...
Hi Excel Experts,
Am trying to find a macro that auto-generate doc ref number sequentially (at the last 3 digits on the right) based on same student's name everytime I click a button. (numbers in the middle are generated randomly).
Expected output :
Name RefNum (cell A2)
Looking to see if there's a way to combine COUNTIF and CONCATENATE formula. Column BB could have duplicates. In column BC, I'm using the formula "COUNTIF($BB$4:BB4,BB4" to give sequential # for dups. I created a column labeled UNIQUE DOC ID, to combine columns BB ad BC using the...
I have rows of data representing drawing numbers within various projects. Each row includes a Project Number in the format n.nn.n and a Sequential Number, format nnnn, within each of those projects. So you could have:
1.11.1 0001 etc
I need to be able to calculate...
I am trying to write some code to do three things...
1. add a new row at the end of bottom of the sheet
2. copy all formulae with it
3. in column A, add Sequential Numbering
I have sussed out the first two but the last one is killing me!
to make it a tad more difficult for myself...
Hi there. So I have a list of name of students. The list needs to remain in a specified order. But, I need to assign a sequential number to each student in a class. Looking for advice on how to do this. The list will never be more than a few hundred lines long. Again, I need the sort order to...
I'd be thankful for any help.
I am wanting to write 01/9/2018 in cell A1 then save it as 01/09/2018.
I then want to open a new spreadsheet and write 02/09/2018 in cell A1 and save it as 02/09/2018
Then 3rd Sept etc all the way down to 30 September. Etc Etc.
At the moment, i am having to do...
I've created a query to return all values in a table where 'Type' is 'A'
Can update queries update the blank 'TypeNumber' fields in sequential order based on the record above it?
E.g.: 'XXX' =...