| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filling a reference series in alphabetical order, not numerical
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Filling a reference series in alphabetical order, not numerical
If B29 etc are cell references, then try:
=INDIRECT(ADDRESS(29,ROW(A2))) and drag down "maub" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change column format? numerical not alphabetical | Excel Discussion (Misc queries) | |||
| How to change column heading from numerical to alphabetical? | Excel Discussion (Misc queries) | |||
| Sort sheet tabs in alphabetical or numerical order | Excel Discussion (Misc queries) | |||
| columns are numerical insted of alphabetical | Excel Discussion (Misc queries) | |||
| Why are my column headings numerical instead of alphabetical? | Excel Discussion (Misc queries) | |||
Hybrid Mode
