array

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...

Hi folks, I am trying to figure out how I can use a loop to 1) establish a number of arrays in a collection and 2) populate those individual arrays inside the loop. Code I am trying to figure out below and a sample mini-sheet at the bottom. Sub MakeAndFillArrays() '######### 'Code should make...

I have a list of 100 customers which are ranked from 1 to 100. Those are from 1 to 50 should have 2 customer visits per year, the second visit is 6 months after first visit. Customer ranked 1 has visits in Jan and Jun, customer ranked 2 has visits in Feb and Jul, customer ranked 3 has visits in...

I'm looking for a way to split comma delimited data (Tags) into separate cells. new sheet shows the data from Tags being split by the comma and inserted into a new cell by itself having the data aligned for that row. it would be great if headers were inserted for the cols inserted as shown in...

I feel like I'm going around in circles between index and more. I have multiple sheets, but for this example just set up the two I needed as they would appear in my workbook. I am trying to make it so that if I select a student's name from a drop down in Column A on sheet 'Student Report' (first...

Hi All, One quick question about an array of numbers within a search function - Can this be done? I have this bunch of nested iferror(mid(seach functions looking for all types of invoice numbers in the cells on our statements, making them easier to find. One problem I face is when a number...

Hello. I'm having a problem where excel will throw a 1004 error "application-defined or object-defined error". The issue is that I have an array of values with strings that look like "=?DAFqwr". As a minimal example of this: Sub testArr() dim arr(1 to 1, 1 to 1) as variant arr(1,1) =...