sort index/match

  1. S

    Issue filtering rows containing INDEX MATCH

    I have ~2,000 rows of information in columns A-M in worksheet "2014_ALL". Column M contains an INDEX MATCH formula which pulls information from another worksheet, "REPORT". My formula works perfectly, however I need to be able to filter and sort the information. When I attempt to sort the...
    • sshea
    • Thread
    • index match index match sort sort index/match
    • Replies: 1
    • Forum: Excel Questions
  2. J

    Sort results of Index/Match array formula OR VBA to paste values

    I'm using an Index/Match array formula to pull out results from a data table (based on three search criteria). The formula works great, except that it populates the results in the same order as the data table - I want to sort them based on another category. My data table is on Sheet 1...
    • JonHaywood
    • Thread
    • paste values sort formula sort index/match sort results of formula
    • Replies: 3
    • Forum: Excel Questions

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