sequence

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?

Hi all, I m presented a problem that I can describe in this way: In A column of numbers, sum only where the formula registers 5 consecutive numbers that are greater than 2 and tabulate the sum of that sequence in column b next to the last counted number greater than 2 in that sequence...

I have a sheet that comes out in a terribly unfriendly format. It has a date that appears in column C at variable intervals to denote the day that the times underneath it occurred. I'd like the first instance of the date in C2 to be copied to A2, and then still paste that same date value into...

Hi I need to translate a seuqence of numbers 01000988 to another sequence format, 0010-01-0988 were the part 0010 is matched to the first four symbols of 01000988 the 01 is just Always 01 and 0988 should match the last 4 of 01000988 this is what I want the results to be 01000988 =...

Hi all, i would like to develop the below VBA code, so that when i save the file "Employees Finger" 2nd, 3rd, 4th time, e.t.c to enter a new sequence number at the end of the file. e.g. "Employees Finger1", "Employees Finger2" and so on..... Tks in advance ChDir "C:\Users\User\Desktop"...