a formula that jumps the same amount of columns

**top_dog** · 03-08-2015, 07:58 PM

Hi

I need a formula that jumps the same amount of columns backwards.

I.e i want the data in a1 then a2 then a3 etc. The information i want in a1 is from n6, in a2 i want information from k6. And so on.

I thought the formula in a1 would look a little like this =offset (n6,column*-3,0). But i am clearly off.

Thanks for any help

**protonLeah** · 03-09-2015, 01:29 AM

Put the values {14,11,8,5,2} in column A and plot a line chart. Add a linear trend line and select "show equation" ----> -3x+17
Replace the x with ROW(), then in A1: (copy down to A5)

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

However, those formulas will error for rows greater than #5

a formula that jumps the same amount of columns

LinkBack

Thread Tools

Rate This Thread

Display

a formula that jumps the same amount of columns

Re: a formula that jumps the same amount of columns

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Need a formula for an amount in a column that is just 2 columns subracted from one another

Sorting a cell amount into specific labelled amount columns

Formula that jumps rows

Summation across of a variable amount of columns VBA formula

Tab key jumps many columns!

Bookmarks

Bookmarks

Posting Permissions