arjen

  1. A

    Highest simultaneous occurence at a time

    Dear all, I would need a formula which gives the highest simultaneous occurence. In this simplyfied example it would 2 for "A" and 1 for "B" Seems easy but I don't grasp it. Thanks very much ... Arjen <colgroup><col width="64" style="width: 48pt;"> <col width="72" style="width: 54pt...
  2. A

    How to get rid of NA results in array formulas

    Hello together, is there a way to avoid "NA" results in array formulas ? I know I could refer to the array formula in another cell but that's not very elegant. Thanks so much. Arjen
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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