| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Opposite direction
Very, very cool. A real life saver. Thanks guys.
Branko "Rick Rothstein" wrote in message ... Cute... I like it! -- Rick (MVP - Excel) "T. Valko" wrote in message ... Another one... =A1+INDEX(B$1:B$5,ROWS(B1:B$5)) Copied down -- Biff Microsoft Excel MVP "Branko Pecar" wrote in message ... Assume I have numbers in cells A1:A5 and B1:B5. I would like to add them in column C, but following this formula: C1=A1+B5, C2=A2+B2,...,C5=A5+C1. How do I do it so that I can just use copy paste of this formula without manually re-entering it in every cell? Thanks. Branko |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Arrow keys moving opposite direction | Excel Discussion (Misc queries) | |||
| How can I paste in the opposite direction? | Excel Discussion (Misc queries) | |||
| My arrow keys in Excel move the opposite direction | Excel Discussion (Misc queries) | |||
| Opposite of Concatenation! | Excel Discussion (Misc queries) | |||
| Opposite of SUM function is ?? | Excel Discussion (Misc queries) | |||
Threaded Mode
