Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Something other than Absolute, Relative or Mixed references
Hi All and Happy New Year,
I want to write a formula like: =INDIRECT(COLUMN()&"1") but the obvious drawback is that column returns a numeric and not an alpha reference. The reason I want this is have a formula that can be copied down and across that refers to the top cell in each column to which is copied. Hopefully my header line makes it clear that playing around with "$" signs is not the answer. I could put in a table with 1 to 26 and A to Z in it and run a Vlookup over it but that just seems too OTT. Probably missing the bleeding obvious again - that and 2.5 weeks off with primo SI NZ sunshine (and beer) rotting my brain. Cheers, Matt |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Switch between relative, absolute, and mixed references | Excel Discussion (Misc queries) | |||
Help with converting a block of cells with Absolute and mixed references to relative references | Excel Worksheet Functions | |||
Relative, absolute & mixed references in many cells | Excel Worksheet Functions | |||
how to switch between relative and absolute references | New Users to Excel | |||
Relative, absolute and mixed values | Excel Discussion (Misc queries) |