array

I have an array that I need to load based on two different filters and then copy data to a new sheet. I have used code from a prior post "Extract some rows to a new sorted list" but need to add an extra filter. I also am getting an error 2015 on the aRws which is not allowing the array to load...

Hi Folks, I am trying to take a wide format array and using vba convert it to a tall skinny format. Currently my xl2bb is blocked so I pasted an example table at the bottom of this. Example wide format on left, desired format on right) My starting code is here. I've tried a few different...

I am trying to write a macro to load an array until a certain value is found. Right now, the user will enter the current month commission, i.e. March. I then need the array to only load the value in column C for February and January, (60 days) then stop so I can execute other code. The array...

MAKECOMBO Function: Returns combination of two arrays =LAMBDA(array1,array2,LET(a,array1,b,array2,La,COUNTA(a),Lb,COUNTA(b),MAKEARRAY(La*Lb,2,LAMBDA(r,c,IF(c=1,INDEX(a,INT((r-1)/Lb)+1),INDEX(b,MOD(r-1,Lb)+1)))))) Here is example (attached image) This is my first lambda function posted here...

Hi, I need to create a 100 × 100 array, which has ones in its subdiagonal elements and zeros in other elements. I also have to use the For next statement. I cant get it right after several tries. This is where I am for now. Could you please help me? Thanks a lot

I don't have access to VSTACK yet, so I am using a workaround to stack many dynamic arrays on top of each other in a list. To do this, my helper array formula is as follows...

Hi Folks, I have an array that I'm trying to write to Sheet 1 of a workbook, but nothing happens and there is no error. It's a macro with a bunch of company references so hopefully the following snippet is enough to get some insight from somebody more knowledgeable. When I check the array...

Hello Excel Experts, I have a potentially novel request: I have 22 sheets with the exact same formatting/cell positions. I would like to grab values from all sheets that meet criteria. If Column C contains "Yes" on any sheet, I would like the sheet name (contained in cell A1), the Building...

Hi, I have a loop that used to get arrays from individual worksheets and then combine and write out to one worksheet. I'm trying to get better at dealing with arrays and avoiding repeated read/write to worksheets...sufficed to say, its still a struggle. Goal: Take each array that populated via...

Hi all, I am trying to figure out how to calculate the Exponential moving average of a stock. The sheet shows the steps involved. I tried using the scan function but I couldn't figure it out. I hope someone smarter than me can help with the formula or point me in the right direction. I know I...

Hello, I have tried VLOOKUP, HLOOKUP, and too many others to list. I think it will be easier to show: So, I have a spread sheet with several different hardware and hundreds of serial numbers. i would like to type in the serial number and see the hardware displayed.

I have been using an awkward method to store and call my UDT arrays by key. That is by making an array and corresponding collection for storing the array index and calling the content by key, please see my code below. Is there better practice for this in VBA? That maybe can call array member by...

I need to Loop though each Cell\Column in "Header Template" finding the Value (a String, ignore the Integers used for an Example) in the Cell, then go look on "Original_Data" for the entire Column and Range of used Data with that name, then paste it on "Formatted_Data". Problem is, on the...

Hello, I am using Google Sheets for this project. I am wondering if there is a way to condense data without deleting rows. In my example below I have the dataset being collected by a Google Form. In cell A9 I have a formula to grab values out of the data set and transpose them. I am wondering...

Hello All, I am using Google Sheets for this project. I have a dataset with many columns that have similar values. In the example below, they are "Gold," "Silver," and "Bronze." I need to filter my data by the person's "Name," and return the column headers in a list. I have almost 100 columns...

Hello, I have a sheet that needs to search for text in a column, and then return the corresponding value next to it. I need the results stacked together so that there aren't blank rows between results. I can't use VBA for this as I'm actually doing it in Google Sheets. Thank you in advance for...

I've made a (really neat, and tough to write!) formula that evaluates a single date against a single cell's value, where that cell contains multiple date ranges, and then indicate whether or not the date is within any of the listed multiple date ranges. The multiple date ranges are formatted in...

Hello excel experts, I am getting very frustrated by what appears to be a straightforward formula. I have a dynamic array spilling vertically, and various numbers for several years found via xlookup. I want to be able to sort this data, so I made another table to grab the array of GL...

Hello, I am new to VBA and need some help. I am trying to delete all the rows of data that I do not want based on the names of people that I do want the call logs for. I think I almost have it figured out but I don't know how to check against an array. The actual spreadsheet I am working with...

Hello, I am struggling with quartile formula to calculate the selected value in another tab based on the description and grade. In the workbook I have one tab with all the data range based on description (i.e. Maths - A, B, C) and in another tab I need to calculate 3rd quartile for grade A, B...