Home |
Search |
Today's Posts |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy the formula by dragging but down but calculate by going left
Hi Frank,
Am Thu, 13 Oct 2016 10:54:39 -0700 (PDT) schrieb F.G.: It works, can you explain how the actual formula works. Row(A1) is the column of the INDEX and will be increased by one when you copy the formula down. Regards Claus B. -- Windows10 Office 2016 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What formula do I use to copy only text on left side of a comma? | Excel Worksheet Functions | |||
dragging formula down makes a copy | Excel Discussion (Misc queries) | |||
Excel VB-Copy formula down until adjacent cell (left) is blank? | Excel Programming | |||
Excel VB-Copy formula down until adjacent cell (left) is blank? | Excel Discussion (Misc queries) | |||
Copy formula relative to left cell? | Excel Programming |