el1

  1. A

    VBA code required to SUM the value depends on multiple criteria

    Hi In the below link excel sheet has dropdown list in the cell P1. In the cell EL1 will shows the results depends on the P1 selection For that, I used If, sumproduct and index match formulas in the cell EL1 as below. --...
  2. J

    Forumula to return value if cells in range are the same

    <tbody> A1 A2 A3 A4 EL1 EL1 EL1 EL1 </tbody> Hi Mrexcel Forum, I am trying to work out a formula that looks in a range to see if all cells in that range are the same and if they are then I would like the formula to return the value that is the in the range. Example: Please see...

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