-
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.
a1a3
-
T
Reversing the order in a sumproduct
Hello, I am sure this has been asked before. What I am trying to do is to reverse the order for a sumproduct: Sumproduct( A1:A3,B1:B3) == A1*B1 + A2*B2 + A3*B3 Instead, what I'm after is Sumproduct( A1:A3, Reverse(B1:B3)) == A1*B3 + A2*B2 + A3*B1 Thank you!- Tkeller
- Thread
- a1a3 b1b3 order reverseb1b3 sumproduct
- Replies: 9
- Forum: Excel Questions
-
Activate Msgbox when cell A1:A3 is selected
Hi All, I'm trying to create a VBA code whereby if cells A1:A3 are selected in a worksheet a Msgbox will produce a message. For example, when in selecting cells A1:A3 Msgbox will produce "Selected". If you can help, please provide a code because I'm stuck. Thank you! Pinaceous- Pinaceous
- Thread
- a1a3 code msgbox produce selected
- Replies: 5
- Forum: Excel Questions
-
D
Double quote with Evaluate() not work
I just try to add Double quote instead of ""O"" but doesn't work [A1:A2] = Evaluate("IF({1},""O"" & A1:A3 & ""O"" &"",""&SUBSTITUTE(""O"" & B1:B3 & ""O"" ,"","",""O"" & "";""& ""O"" &A1:A3& ""O"" & "",""& ""O"" ))")- Dossfm0q
- Thread
- a1a2 a1a3 double evaluateif1 work
- Replies: 2
- Forum: Excel Questions
-
C
VBA Reducing Number of Rows
Hi, I'm trying to reduce the number of rows in my range by a value, usually 1 or 2. So essentially, Im trying to go from having my range being A1:A3 to A2:A3, I am able to do it the other way round (A1:A3 to A1:A2) but not this way? Any ideas?- CLM_96
- Thread
- a1a3 ideas number range rows
- Replies: 2
- Forum: Excel Questions
