I am wondering if there is a way to drag a formula, for instance, down, and each cell that I drag down, it references one cell to the right.
Excel Example.png
I attached a photo -- I understand that this is an overly simplified example, but the idea is that it would reference the row as you drag down the column.
Thanks!
T
hi T, welcome to the forum. 1 way is to use INDEX, MATCH & ROWS. assuming your 1st formula is to be based on B1 & you want all the info in B1:K1, then:
=INDEX($B$1:$K$1,ROWS(B$1:B1))
ROWS(B$1:B1) will return you 1. because that's the total rows in that range. if you drag down, it will be ROWS(B$1:B2) & will return you 2. the INDEX will return you the first column of that range, followed by the 2nd, & so on.
is that what you need?
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
With these values in B1:K1
Jan
Feb
etc
Dec
This regular formula begins the vertical list of those values:
Copy that formula down through A14
A3: =INDEX($B$1:$M$1,ROWS($3:3))
Is that something you can work with?
I guess my question is more - is there a way to set up a hotkey so that when you drag down it pans across, or vice versa?
You could maybe use a macro to do most of what you want. Maybe.
(Hey, how'bout this weather!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks