array

  1. C

    XLOOKUP on Array with Same Entity on Multiple Lines

    I am trying to add classifications to my leagues based on year. Some leagues change classifications on a year-to-year basis. I am trying to use XLOOKUP to look up the year and the league, and select the proper classification from a range. The problem arises when a league changes...
  2. F

    How to multiply two arrays together

    I am trying to do an array multiplication, multiply each of the months with the corresponding numbers from the 'Array' below, for example for "Person 1" do 0.1*150, then 0.2*250 and so on. As you can see it is returning #VALUE. Even if I try multiplying as an array, or multiply the numbers one...
  3. A

    If value is contained in array

    Hi Helpful folks of MrExcel, hope you can help me with this problem I've been stuck on. I have an array of values in one column and in two other columns I have the year and an amount. What I'm trying to so is create a third column (H) and say if year is contained in array *2, otherwise *1...
  4. J

    Google Sheet - Count Drop Downs, Total Columns, Check, Array - Errors

    Can someone please fix this Google Sheet for me? I need it desperately for work. I cannot figure out what I'm doing wrong, and every formula I've looked up doesn't work for me. It's driving me CRAZY! o_O I've highlighted the columns that are giving me issues in yellow (sheet linked at bottom of...
  5. T

    Remove Duplicates Multiple Columns

    I cannot figure out why I am getting a "Subscript out of range" error with this line: WS.Range(Cells(1, 1), Cells(5, 3)).RemoveDuplicates Columns:=Array(2, 3), Header:=xlNo
  6. K

    Array SUM or SUMPRODUCT function error

    Hi! I have been working on implementing MRP Excel solution in a company I work for. I have already done one, and now I was working on a new more detailed system. My company prohibits me to install XLB2BB add-in so I will do my best to explain everything. First sheet 'ProdBOMs' contains Bill of...
  7. OvernightCellebrity

    Unique + Filter?

    I would like to pull all unique values from collumn D:D based on one criteria. Criteria Portfolio Name in (A2) Collumn of portfolio names: AA I want to avoid using an array formula is possible, whatis the simplest way to achieve this i have tried the below: =UNIQUE(FILTER(D:D, AA:AA=A2))
  8. mohsinbipu

    Count the occurrence with the array formula

    Hello Excel lovers, For a better understanding, please find the picture. Here, my input Column is I, J, K My output column is the P column (I want to get the Xlookup result for nth number.) To count the number of occurrences, I add a helper column L I don't want to add this helper column. I...
  9. B

    Groups/Arrays/Patterns Help

    Strap in, this is gonna be long and possibly confusing. I have to test and record the first and last data point in groups of 25. Each quarter, the iterations change, so in Q1, I'm testing 1, 25, 26, 50, 51, 75, 76, 100. . . In Q2, I'm testing 2, 24, 27, 49, 52, 74, 77, 99. . . and so on...
  10. F

    Power Automate and Arrays

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

    IF(ISERROR Array formula

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

    Need help with logarithmic function

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

    Array

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

    Array FOrmula or Setup to make data Power BI compatible

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

    Find list of words in range for array formula

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

    Populate an ActiveX combo box according to a List Box values

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

    Dictionary with array as the value

    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)...
  18. C

    Can you use an Array within an IF statement, using AND as well?

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

    How to Replace All occurrences in Array?

    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?
  20. FuNeS13

    Loop through column titles (1st row) if name is in 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"...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top