excel array formula

  1. rette

    Excel to Mail Merge Question

    I am beyond frustrated and my perfectionist nature won't let me give this one up and I know there are some geniuses here that can help me find a solution but I can't take another YouTube video or confusing tutorial. I have a data source that contains giving records, most records have 12 entries...
  2. T

    Alternate for Array Sum Formula

    Can somebody please suggest an alternate to this array formula so it can calculate way faster {=SUM( IF( ($B$2:$B$10=$C15)* ($C$2:$C$10=$C$13)* ($D$2:$D$10=D$14)>0, IF( $G$2:$G$10<>"", $G$2:$G$10, IF( $F$2:$F$10<>"", $F$2:$F$10, $E$2:$E$10))))} I have tried below which reduces the calculation...
  3. A

    error message when entering array formula

    Hi, I am trying to write an array formula for median if statement. =median(if(A25:A223="End Customer")*(A25:A223="Partner"),G25:G223)) the hit control shift enter..for the array excel keep popping up there is a problem with this formula .. not trying to enter a formula.. ( I tried retyping...

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