Filling a reference series in alphabetical order, not numerical

M

maub

I need to fill formulas from another worksheet as following: B29, C29, E29,
F29, etc... Instead, Excel fills the series as follows: B29, B30, B31, B32,
etc... I wanted to know how to change the sequence.
 
R

Ron@Buy

If B29 etc are cell references, then try:
=INDIRECT(ADDRESS(29,ROW(A2)))
and drag down
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I resort numerical info into numerical order 1
how to design spreadsheets to collect data and display the totalmaterial used in a plating departmen 13
How do I drag a hyperlink series to fill instead of copy? 2
Redesign for hitting limit argument in a UDF 18
Locking a cell reference in a formula 1
How to Auto Reference Worksheet Tab ID's in Formulas? 9
Change a column numerical to alphabetical 0
Filling series 4

Top