I'm using Excel 2007. I'm trying to reacreate the pattern shown in the sequence column. Could someone please give me a pointer as to how I could do this?
Hi there everyone
I'm new here and come here to find some help about a problem that seems easy to solve but i can't do it. It has 2 parts this problem
The first one is i need a solution to automatically fill in the serial number column (column C) sequentialy and acordding to column A (example...
Good Afternoon,
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...
Hello
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...
Hey all,
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
20 PS001
32 PS002
20 PS003
-20 NE001
10 PS004
20 PS005
-10 NE002
10...
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...
Hi
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
<colgroup><col><col></colgroup><tbody>
<colgroup><col><col></colgroup><tbody>
F19130
F19130
F19130
F19130f
F19131
F19131
F19131
F19131f
</tbody>
Can it be done?
Thanks for any help
</tbody>
Hello,
I am attempting to do the following and would appreciate any help:
I have a spreadsheet that looks like the following
<tbody>
ABC
ABC-001
DEF
DEF-001
ABC
ABC-002
ABC
ABC-003
DEF
DEF-002
</tbody>
I manually enter in the information in the first column. In the second column, I...
hi all..
how to make sequential number with parameter
my target in column "interval" and "given" number as parameter (based on)
like this layout :
<style type="text/css">
table.tableizer-table {
font-size: 12px;
border: 1px solid #CCC ;
font-family: Arial...
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?
Hi,
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)
Darwin...
Hello,
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...
Hi
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.03.1 0001
1.03.1 0002
1.11.1 0001 etc
I need to be able to calculate...
Hey guys.
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...
Hi
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...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.