Skip to main content

/ Useful Technologies/ Group items tagged offset

Group items tagged

Filter: All | Bookmarks | Topics Simple Middle

Excel formula to reference 'CELL TO THE LEFT' - Stack Overflow - 0 views

stackoverflow.com/...-to-reference-cell-to-the-left

Excel reference cell offset function useful_utility

shared by George Bradford on 18 May 16 - No Cached

George Bradford on 18 May 16

" 1 down vote Instead of writing the very long: =OFFSET(INDIRECT(ADDRESS(ROW(), COLUMN())),0,-1) You can simply write: =OFFSET(*Name of your Cell*,0,-1) Thus for example you can write into Cell B2: =OFFSET(B2,0,-1) to reference to cell B1"

<div class="cArrow"> </div><div class="cContentInner">" 1 down vote Instead of writing the very long: =OFFSET(INDIRECT(ADDRESS(ROW(), COLUMN())),0,-1) You can simply write: =OFFSET(*Name of your Cell*,0,-1) Thus for example you can write into Cell B2: =OFFSET(B2,0,-1) to reference to cell B1"</div>

...

Cancel

1 - 1 of 1

Showing 20▼ items per page

Related searches