multiple result

  1. J

    #NUM when looking for second result using MATCH INDEX

    I am trying to summarize available inventory for certain projects in a new document. I have used SUMIFS to total the number available using three criteria: Species (Column D in my inventory document and column A in my summary document), Zone (Column A in my inventory document and column C in my...
  2. S

    Function to conditionally sort data

    I had a question regarding a fix I am in while trying to analyze a data. Here's what I am lookin for. A B C D 14 6331 14 8164 14 4731 14 6416 14 8106 15 4764 15 6218 15 6256 15 6372 16 6422 16 4829 16 4941 16 4963 17 6212 17 6371 18 6582 18 6642 18 8143 19 6349 19 6611 19 4710 20...

Watch MrExcel Video

This Week's Hot Topics

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
Top