1. E

    Json Excel Square Brackets within Square Brackets Run-Time Error '1004'

    Hello, I have a json file which I am parsing to excel, but one of the fields I need to pull doesn't work. The only difference I can see between this field any all other fields, is that this field is within square brackets, whereas all my other fields are not. I get an error Application Defined...
  2. R

    Sumproduct not working

    Hi, I'm trying to calculate the headcount & salary by allocation for a 5yr period where the salaries change every year, but the headcount allocation stays the same. I think im doing something very silly as the sumproduct formula that im using doesnt seem to work. Frmula used in F20 calculates...
  3. staticfluids

    Distribute Number into Several Part (Increment) Based on Other Data (Dynamic Array)

    Hi all, I hope you're doing well. First of all, sorry for bad explanation as my main language is not English. I'm currently using Excel 2021 and trying to experiment with Dynamic Array formula. It's quite helping with my daily Excel use. 2 of my latest question was asking about Dynamic Array...
  4. staticfluids

    Dynamic Array Formula (FILTER) But Show the Other Criteria with Blank

    Hi, first of all, sorry for my bad English. I have been looking for a solution here, trial and error by myself, and the Microsoft forum as well. But haven't found any solution that satisfies the needs. I think it's possible but I don't know how to put it into Excel formula. The logic is like...
  5. B

    Add new Row in ListObject Table with data from an Array

    I have a Table, with 144 columns, consisting of strings that I convert to Formulas in another Table. Work around for Volatile function Indirect when I add and remove Sheets, but need the Formula NOT to go #REF.... SO - I have an 1 dim array and would need each data to be written/saved in a new...
  6. D

    Userform: Populating Cells based on the information selected in the Combobox

    Hello! I'm still a newbie to the VBA and Userform usage. I have developed a Userform that will input the information from the Userform into the cells I have designated. I'm still trying to understand Arrays. But I have it setup in array for Vendor and Probe Type: Private Sub...
  7. P

    How to use a MATCH helper column containing rows from a different sheet and INDEX in an array formula to return based on data in the helper column?

    I am trying to use MATCH and INDEX to improve performance on a google sheet that has way too many XLOOKUP functions. I have a helper column (DH) that lists the matching ROW I need from the Visibility sheet. This formula returns the expected result from column 9 on the Visibility sheet, where...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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
  13. 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...
  14. 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))
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. R


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

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