muliple matches

  1. S

    Return multiple hits

    Hi Guys, I have a table that manages my masterdata. In that table is the material number, and the last successor To explain, I will use an example, and in this case materials A,B,C and D are all superseded to the new material E So we could have something that looks like this Material...
  2. E

    populated array from multiple same small results

    Hi, I work with copiers, and have been using this formula to populate a single cell in a monthly spreadsheet from two other spreadsheets based upon a small set (1-5) click count on each machine (also in a separate spreadsheet.) Normally, I do not get two machines that have the same copy count...
  3. W

    Matching multiple rows??

    I have a table where I want to match data to a reference. The reference appears in more than one row in the first column and I want to find out which row numbers that reference appears in. However, using MATCH I can only find the first time that reference appears. Is there another way of finding...

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