-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
excel array formula
-
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...- rette
- Thread
- excel array formula if formula excel help logical check
- Replies: 1
- Forum: Excel Questions
-
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...- tabbymulla
- Thread
- $d$2$d$10 $f$2$f$10 $g$2$g$10 excel array formula h$14
- Replies: 9
- Forum: Excel Questions
-
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...- ariel20029
- Thread
- array cells enter excel array formula formula
- Replies: 5
- Forum: Excel Questions
