It looks like what you want to do is to transpose a range. You are
converting a vertical range (A1:A10) to a horizontal range (A1:J1).

Here is what you do:
First, determine how many rows are in the source. In the example above,
there are 10 rows. Next, highlight the destination of these ten rows, say
columns B1:K1. (note, you cannot have an overlapping section. A1 cannot be
in both the source and destination)

With columns B:J highlighted, enter into B1 this formula:
=TRANSPOSE(A1:A10) and press Shift+Ctrl+Enter. This is an array formula
that will transpose the values. When you make changes to the values in
A1:A10, those changes will show up in B1:K1.

If that approach won't work and you still want to try your question, post
back and we can work it out. The solution is slightly convoluted, so let's
try transpose first.

--
Regards,

PJ
Please rate this post using the vote buttons if it was helpful.



"CM" wrote:

I've searched for an answer to this problem and learned about using the $ to
keep the row or column constant, but it does not seem to work the way I want
it to.

Problem: Formula is =I28
I want to drag this formula to the right (across columns) and have the
column ("I") stay constant, but the row number increment. Ideally, the
formulas from left to right would be =I28, =I29, =I30, etc...

=$I28 results in the same exact formula (=$I28) in every cell
=I$28 results in: =I$28, =J$28, =K$28, etc.

Is there some way to do what I want to do?
--

Thanks,
CM