sequence

can anyone come up with a replica for the sequence function for Excel 2016? not the type which spills over, but rather one you can use in 1 cell. Lets say MyCustomNumber = 4 for example, instead of doing =ROWS(INDIRECT("A1:A"&MyCustomNumber)) to generate ={1;2;3;4} when evaluating [F9] in...

Subject: Automate the reorganization of two columns based on the unique identifier "Name", and a corresponding "Reports-to" column. Version: Office 365 OS: Windows 10 Urgency: Low Examples Included So I have a project that I am trying to work on in my free time (but could use some help with) to...

Hello, I am having difficulty with assigning a specific sequence of numbers (seat numbers listed below) to specific records whilst keeping the order. For context, I have a running order of graduands and those known to be attending are marked as attending in column C as well as the row being...

I have a sheet that I need to autofill down from a cell value. So item A to repeat its name 40 times starting on sequence 1 than immediately after Item B 10 times and so forth. The order of Item A-D will change as well since sometimes I may want Item B first than Item A etc. Thanks for anyone...

To set the scene: I have 800 or so products, each with a unique identifier. These products have associated notes on a system, each with a varying number of notes. These notes are managed on an Excel document. Therefore, on a spreadsheet, I have groups of products. Some are in groups of 2, some...

Hi all thanks in advance for answering. Is there a formula that will give a sequential code to a range of alphas and the sequence resets to 0001 when the alpha changes? I.E a customer code file would generate the following: ABCD0001 ABCD0002 ABCD0003 DEFG0001 HIJK0001 HIJK0002 HIJK0003...

Hello to everyone. I saw these new features on microsoft office web sites. Are not available yet? I Use office 2016(365). FILTER function RANDARRAY function SEQUENCE function SINGLE function SORT function SORTBY function UNIQUE function

Hello everyone. I am trying to create a function that runs smoothly. Currently i am using a bunch If/Then statements to return values (about fifty) . The tricky part is i need to return strings from numbers. For instance if the value is 1 return apple. The issue i am having is the keys are not...

Hello Friends, first time posting here as I have a frustrating excel problem at work. It is so simplistic to explain that I couldn't find any similar problems on the search tools here, and I am sure the answer will be embarrassing to me. I have a example sheet to provide but it says I can't...

Hi guys I am trying to extract a set sequence of 12 numbers from various Ebay URL's. Here are a few working examples...

Greets, I am trying to determine the easiest way to find a missing alphanumeric, alpha, or numeric sequence in a excel. I believe the functionality is already there in excel just not sure how to do it or where to start. Any help would be appreciated. Use Case: I am trying to find all the...

Good afternoon, May I please ask for your help with 3 formulas? Below is a tabwith sample data. The highlighted columns are the ones requiring the formulas. Unfortunately this seems to be beyond my excel knowledge Formula 1 (Cntl Cnt - column C): I would like to have formula to count lines...

Hi All Scratching my head a bit with this one. I've code that loops through some cells and look for a certain sequence of letters and numbers and if found, copies it. The sequence used to just appear as the first 7 characters so I could just check for it there, however a recent change 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...

Everyone knows Excel can continue 1,2,3... to 4,5,6 and Monday, Tuesday, Wednesday to Thursday, Friday, Saturday. But what if the sequence is much more complex? Like for example, given list: 10 6,025 3,77 2,52 1,77 1,32 1,01 0,805 0,645 0,53 give me the 50th entry on that list. What's the...

Good day, I need to combine this function with vlookup. Due to i need to ensure no bar code data are missing if something occur while handling this. =IF(A10="","",IF(A10='BARCODE REGISTER'!A10,"PASS","NG")) So if someone scan without follow the sequence number. The bar code will also detect...

Hi, I need some help to get Excel to extract all the smallest numbers [RED] in a repeating data sequence that goes from maximum to mininum and back to maximum... <tbody> <tbody> <tbody> 11-Jan-03 162.63 12-Jan-03 151.60 13-Jan-03 140.43 14-Jan-03 129.08 15-Jan-03 117.48 16-Jan-03...

Hi all, I am frustrated. My Engineers and I manually convert strings of numbers into sequence numbers for our ERP system. It is waste of time and brings in the chance for errors. SolidWorks (CAD) spits out a number = 1.2.3.4.10 and we change that to Sequence Number = 010 I really have a tough...

I want to count the sequence of positive number from i4:i20, if i4:i20 there more than one positive number than it will count the sequence, but only if there more than one positive number from i4:i20?