index & large

  1. J

    look up maximum value in range and return corresponding values in another column

    I have a dataset (see sample below). What I'm looking to do is return in one cell where the highest unique count is the same for different periods. I have found the below array formula, but would prefer not use this, as the actual data will be quite large. =IFERROR(INDEX($J$8:$J$500...
  2. R

    Formula Support - Top 10 list using Index and Match

    Hi, I am currently building a top 15 list for a report which is based off a table of data. Currently i have the below formula but it is only showing the first item when there multiple of the same value. My formula...
  3. N

    Using MAX() to output multiple values from one formula

    Hello (again) mrexcel forums, I'm working on a formula which outputs an array of values in an n*m grid, where the size of the grid may vary a lot between use cases. I've been getting good mileage with using arrays as named variables in equations, but i'm having trouble with the MIN/MAX...
    • nicklasx
    • Thread
    • array dynamic array index index & large match offset sumproduct vba
    • Replies: 0
    • Forum: Excel Questions
  4. A

    Return corresponding names in descending order based on next column values.

    Hi everyone, Column A1:A5 contains unique names/references Column B1:B5 contains numbers I want column C1:C5 to be those names but based on their corresponding values in descending order. I don't want to do any filtering, a function on C1 to read values from B1:B5 and return corresponding...
  5. C

    Formula to use to find top 3 and the adjacent cell label?

    Hi, Need help with a formula that will find the top 3 in a table and place the item in cell before. In bottom table, D will have formula that will pick up 420, and C2 will pick up SQuash, then D3 will pick up 325 and C2 will pick up Okra. and so on. I found how to use =large to pick up in order...

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