Hello,
I have noticed that every time I have a range in formulas, say A2:D2, Excel takes the range elements from A to D. And if I try to write D2:A2, upon pressing cntrl+shift+enter, Excel auto-corrects it to A2:D2. So I have been trying to look for a way to specify a range such that Excel would consider it in the reverse orientation. Here is a simple example for the formula {=SUM(A1:D1*A2:D2)} which returns the value of 40 assuming the default direction of A2:D2 range:
However, the result would be 30 if the direction of A2:D2 was reversed to D2:A2:
But could this have been achieved without having to manually rewrite the range in the reverse order? (I'm trying to learn a generic way of doing this so that I can apply it to various situations as I often come across long ranges that have been written in the reverse order and flipping them manually would be cumbersome).
Thanks for any input!!!
I have noticed that every time I have a range in formulas, say A2:D2, Excel takes the range elements from A to D. And if I try to write D2:A2, upon pressing cntrl+shift+enter, Excel auto-corrects it to A2:D2. So I have been trying to look for a way to specify a range such that Excel would consider it in the reverse orientation. Here is a simple example for the formula {=SUM(A1:D1*A2:D2)} which returns the value of 40 assuming the default direction of A2:D2 range:
However, the result would be 30 if the direction of A2:D2 was reversed to D2:A2:
But could this have been achieved without having to manually rewrite the range in the reverse order? (I'm trying to learn a generic way of doing this so that I can apply it to various situations as I often come across long ranges that have been written in the reverse order and flipping them manually would be cumbersome).
Thanks for any input!!!