sequence

Hi all I'm wondering if you could help or at least suggest options. I have looked through loads of threads and have been able to add rows using a message box but I need to then autofill them cells added with a sequence. Sub MyInsertRows() Application.DisplayAlerts = False...

Hi there, I have a huge data set (10 units and 5 years data set) that contains for each unit an indicator whether a unit is fully or partially operational or zero if not in operation. I am interested to know the number of blocks (a block is defined as a sequence of fully or partially...

I imagine this is painfully simple, yet all my research and trying to figure it out on my own has led to failure. I've learned how to create a button in Excel and create code in VBA to have that button change cell values. The problem is that right now I only know how to affect one cell at a...

Hi all, I'm working on a workbook containing 150 sheets, 50 of which has "sales" in the sheet name. Is there a function that sum the same cell (like D3) of those 50 sheets? They are not in sequence, the 150 sheets are mixed up. Can we use a formula like - =sum( "'Sales" & "*!'" &"D3" )...

Been trying to figure this out lately- I have excel data in a unique system where a cell has multiple values for SKUs For example 1231223525 123512AA12 bR1124ABAGGA i was hoping if there is a formula or a Sub where we can run it on the cell like MID(A1, (LEFT(A1)=",") + 1, LEN(A1)) to...

https://www.dropbox.com/s/amwx4p2ofoau8w3/Example.xlsx?dl=0 <colgroup><col width="64" style="width:48pt"> <col width="64" span="20" style="width:48pt"> <col width="64" style="width:48pt"> </colgroup><tbody> 1 A B C D E F G H I J K L M N O P Q R S T...

Hello! I need your help in below query. I am looking for a VBA program that help me to add next sequence number in next blanks row cell only (one cell only). For example, 5th row is blank cell, i need to place next sequence number as "3". Similarly in the same column, refer row 9, i need to...

Hello! Why dragging =COLUMNS($C$11:C11) from C11 does not create a sequence of 1,2,3,.. but instead creates 1,1,1,..? thanks!

Hi Would like to know the correct VBA of printing hyperlink pdf invoice in excel in the sequence that have been send

I have to populate various spreadsheets using the following number sequence: 1,1,1,1,1,1 2,2,2,2,2,2,2,2,2,2,2,2,2 3,3,3,3,3,3 4,4,4,4,4,4,4,4,4,4,4,4,4 etc.. So basically, I have to follow sequential numbers in the special pattern of 6 instances of 1, 13 instances of 2, 6 instances of 3...

Hi, I'm have a large data set and am trying to identify a formula that will make a calculation based on the sequence number. Example below. From a lookup I have identified that a quantity of 3 are packed, but I want the 3 to be deducted from the first schedule line only, and if the schedule...

If I have a long list of numbers, how do I find where that list of numbers is not consecutive. How do I show when the sequence changes from 5 to 8 and from 9 to12? 1 2 3 4 5 8 9 12

</SPAN></SPAN>Hello,</SPAN></SPAN> I am looking a specific solution for my need, Count "0" after all specific numbers are listed in cells F5:F24 and result of count show in the cells G5:G24 as shown in the example below...</SPAN></SPAN> In the data Column D number of sequence is broken by...

Below I have written a sequence of #'s in Red. I would like to be able to type in my sequence (usually a 1-20 digit #) and then put how many iterations i would need in Red below that. I would then get my sequence generated in column "A". Thanks in advance to anyone who gives this a shot...

I use this to drag down alphabetical letters: =CHAR(CODE(A1)+1) It works, but only up to Z! What do I use to continue the sequence through to double letters like this: AA AB AC AD Thanks for your help!

Good morning. I am trying to find a way to automatically generate a sequence number when data is entered. I have to report out of a large spreadsheet which tracks tasks completed. The spreadsheet is used by a half dozen people from a shared location. They can be in and out of the...

Hello,</SPAN></SPAN> Require VBA which can colour number of sequence with 3, 4 different colours </SPAN></SPAN> 0 = no colour, all 1=single colour, rest 1+2, 1+2+3, 1+2+3+4, max sequence I got </SPAN></SPAN> 1 to 14 </SPAN></SPAN> Here is an example... </SPAN></SPAN>...

The revised calculation engine for Excel365 includes new functions that spill and allow for dynamic arrays. Using this new technology, it's easy to create a loan amortisation schedule that omits the need to create the correct number of rows or complex formulas to account for the correct number...

Hi, I'm trying to formula that returns a cell value from a column that's adjacent to the first and last instance of my reference cell. Here's a sample of the data: <tbody> Date Order # Sequence 3/15/2017 301330920000 20 12/13/2018 301358930000 10 12/13/2018 301358950000 10 1/9/2017...

OK real simple one I just can't think how to do it... I have a column A which is where I want my numbering to count up Column B has company names In All the company names are In order but there are multiples of the same company name so: Abc Abc Abc Abc Def Def Ghi Ghi Ghi And so on...