array

I have created a form that requires people to upload a file for documentation. I would like to rename and save that form to specific folder on my OneDrive. I am able to save the file to my OneDrive but I am having difficulty renaming the file. In Power Automate, I have successfully parsed the...

I'm trying to write a formula that looks for duplicates and returns a specific text value if a duplicate is present. I'd ideally like to do this without nesting multiple if formulas as this might slow down the workbook. What I have so far is...

Hello everyone! I have a database in Google Sheets of materials (leather, steel, etc..) that have different modifiers (100%, 70%, etc...). This creates a curve that interpolates between the points. My issue is that in Master!D:D I wrote the following formula: =IF(E3<0...

Hello! This is not a formula related question. I want to understand more on arrays. When and how should you incorporate them?

I have data as per Image 1 and I need it to return it as a list as per Image 2. So basically the excel file is a Construction equipment workbook with separate sheets for separate construciton equipment. How to do it. I want this data as a list such that it can be used in Power Bi. The data in...

I have a spreadsheet that I am trying to populate by using an array formula. Right now, I have a formula that looks in a range and identifies if the word "Spouse" is within it. However, I would like to update the formula to search for "Spouse" & "Ex-Spouse" within the same range, but my current...

I have a ListBox that is filtered by a TextBox, but I want it ot be filter by a ComboBox as well, This means that If the TextBox is filtering specific values, the values shown in the ListBox must be shown in the ComboBox. This is a visual example of it And this is the code that I'm using for...

Hi, I have been battling to understand why an array is not being updated where the array is in place of a key/value pair. I have the following in VBA: Dim testDict As Object Dim testKey As String Dim arr(1) As Double Set testDict = CreateObject("Scripting.Dictionary") testKey = "TestKey" arr(0)...

Hi All, I have compiled this code, but I want to tidy this up and if possible, have arrays so that it would be easier to add more variables in the future. In a nutshell I want the macro to look at Column AA for anything in the array AND if column AC has a specific text to then give me the...

Hi all, Having a one dimensional VBA array, is possible to find a list of strings and Replace All occurrences of each string within array?

I know I'm doing something wrong in this part of the code, but I don't know what... Dim MyArray As Variant Dim found As Boolean Dim uB As Integer, lB As Integer Dim LC As Long MyArray = Array("Type", "Number", "Order", "Invoice Date", "Due/Paid Date", "Amount", "Shipment", "Customer"...

I am trying to use a range as the items in an array Using the Microsoft Office Sales data In the cell j3 I have the formula =SUM(SUMIFS($E:$E,$D:$D,"="&J2,$C:$C,{"Jones","Gill"})) Can I write this so that it picks up the names from the cells j6:j7 e.g...

I am preparing a cashflow model which has a column with years starting at say 2023 going on for several decades. I wish to make a periodic income in the adjacent column that starts in say 2025 then repeats every say 3 years. Could someone help construct a formula for this? The start year, the...

Hi, I was looking at an old topic from 2014 and I am trying to extend an array formula to stack data from 9 columns ignoring 0 and blanks. My workings are in below screenshot; and sample data is as below; ABCDEFGHIJKLMNOPQR11700000002232563Entity 1Entity 2Entity 3Entity 4Entity 5Entity...

I have 3 workbooks, one of them (wb1) has a vba code that copies some formuled cells (a1:c23) in a worksheet from wb2 and copies them in a worksheet in wb3. The thing is that the formulas copied in wb3 are referencing the wb2 instead of wb3, how to copy without this reference?

The last argument in XLOOKUP allows performing a binary search but XLOOKUP only returns one match. IF(value=lookup_array,return_array,"") returns all matches in an array but is slow on large lookup ranges/does not do a binary search. Would anyone know a fomula - or combination of - that both...

Hello dear experts, I am writing to you today to ask for your help in reviewing my code. I have been working on this code for a while now, and I am finally ready. However, I would like to get your feedback on it. I am especially interested in your feedback on the following: The overall...

Hello, I am trying to create a function that will let me input a number, and the function will do the following: Add the digits in that number togeather Check if the resulting sum is a single digit (1-9), 11, or 22; Return the number if the #2 is true Start Back at #1 with the new number...

Hello, I'm trying to refer to a textfile and set that as an array, but i'm met with an error when trying to refer to ThisWorkbook.Path (Bad file name or number) And I don't understand how to fix it. I'm using the same type of argument to open/refer to a Workbook, and this works just fine. I'm...

Hello, I'm having troubles figuring this out. I have an external Array in a notepad, where there are a Bunch of strings. I Want to make a new Array from a line from this Array. Say "Arr(0)" contains the following:1 2 3 4 5 6 7 8 From there I want a new array (lets call it nArr) that can...