sequence

Hi, Can someone help me, sorry for bad English since it is not my native language here. Ok, I want to find what number in column show "most repetitive/duplicate in SEQUENCE". Im dealing about 100 000 data in a single column. Here what i have tried: (1) I tried use the "most frequently...

Let’s create a dynamic calendar in Excel the quick and easy way. We can use the clever new Excel function SEQUENCE in Excel 365 Insider. Mr. Excel (Bill Jelen) sparked this idea with this video and I enhanced the concept so that all we need is a date to make the calendar matarialise in the...

Hi I am trying to consolidate about 30 documents into this one master database with Power Query. When expanding all my tables, it seems like the Item column isn't populated for some of the documents. The Occupancy(%) column is organised in a sequence of 5 items for 3 KPIs. > I would like...

Hi, I have a large data set with more than 15k rows. in one file (Say: File A) there is an SKU and Bin Location for all rows. And in the new file that I'm now working (Say: File B) contains the SKU number and I require to pull the corresponding Bin location. The challenge is that in File A both...

Hi, I have an hard time being able to figure out a solution to my issue and would like to see if anyone can help or has ideas of how this challenge can be resolved. I am trying to find a formula that is able to tell me if a cell has changed from a number to a text (horizontally) resulting in...

In order to generate all the permutations for three variables, put the variables in an Excel Table (which is called Inventory here). You can add as many rows to the Table as desired and you can fill in all or just one of the rows for each variable. The exemplar here will spill down 60 rows, the...

I enter the number 45 into cell A1. A2 formula: A1+1 (Returns "46") A3 formula: A2+1 (Returns "47") A4 formula: A3+1 (Returns "48") I have this sequence for about 200 rows. I understand that you are able to just drag down to continue the sequence of consecutive numbers although this is in...

I have one excel file where data is entered, and then transferred to another excel file with macros. On the second excel file I would like a macro that inputs a sequential number for each day in column A, and a sequential number for each week (or Month if week isn't possible) in column B. The...

I am not sure this forum is the right place to ask about this. I use Excel 2013 and have been looking for a downloadable add-in of the sequence function. Is there such an add-in? If so where can it be found?

Hi, I have the following formula in cell K1 =LEFT(ADDRESS(ROW($AA1),COLUMN($AA1)+(COLUMNS($K1:K1)-1),4),2) I need to copy & past this formula 6 rows to the right each time (i.e. Q1, W1, AC1 etc) And return the following sequence in the cells; K1 - AA Q1 - AB W1 - AC AC1 - AD The formula...

Good day! I have dataset that looks like this (let's assume that "Name" is column A and "Sequence" is column B): <tbody> Name Sequence BUNNY 1 BUNNY 2 BUNNY 3 BUNNY 4 TIGER 1 TIGER 2 TIGER 3 TIGER - DOG 4 DOG 3 DOG 1 DOG 2 </tbody> I am in the need of a simple...

I have a list of Invoices with a Date and Email Addresses from a sales database. I have counted the number of invoices per email address...but now I need to mark each invoice as "First / Second/Third, Fourth, Fifth Order .. basically what sequence.... I am trying to calculate the number of...

Hi All, I have the following data set: ID Sequence Type Time R0000039 0 Manual 03:11:45.014 R0000039 1 Manual 03:11:45.018 R0000039 2 Manual 03:11:45.441 R0000059 0 Manual 03:14:33.857...

This site has helped me in years past and am stumped again. I have a spreadsheet of many rows. Column A is list of names Joe SMith Joe Smith Jane Doe Jane Doe Jane Doe Rick Smith Rick SMih I want to be able in column B to put in a sequence number so that both Joe Smiths end up sequence 1...

Greetings! I have a question that I believe it should be fairly easy to resolve for someone with experience. I have a data set that looks something like this: <tbody> Run Order Sequence CAR 1 2 CAR 2 1 CAR 3 3 CAR 4 4 APPLE 1 2 APPLE 2 1 APPLE 3 3 APPLE 4 - SODA 1 1 SODA...

If you can do this , you are a genius!! formula for a roulette betting system in excel based on the Fibonacci sequence. The sequence goes like this: 1 – 1 – 2 – 3 – 5 – 8 – 13 – 21 – 34 – 55 – 89 – 144 – 233 – 377 – 610 – 987 – … You might have noticed (or you already knew) that each of the...

I have a standard report which I need to sort in the same way everytime. Is there a way to save the "sort" sequence and apply instead of re-creating each time? Thanks in advance!

I would like to populate a value in cell say a9 to a50 based on a value in cell say g5 I want to populate cells from a9 to a50 based on the following conditions: the cell a9 will be 1 and the value cannot exceed the value in cell g5 assuming the value in g5 is 20, then the cell values from a9...

Hello, I am looking for a formula that can determine the next sequence of a number from another sheet if there are 7 sequences each starting with a letter. For example: A001 B001 C001 D001 E001 F001 G001 I know that formula: =MAX('Sheet1'!A$1:A$1000000)+1 works to find the next sequence of a...

I have a list say: A,B,C,D,F (IN COLUMN A) I want the user to select a member of the above list in column B1 and say how many times it must be repeated in column C1. The extracted list can now follow in any other column (a multiple of times say 2) Example. User selected A Repeat 3 List 2 times...