Using rangename in relative reference

  • Thread starter Thread starter Arthur
  • Start date Start date
A

Arthur

Say I have 12 months of data in 12 columns of one row. I'd
like to create a rangename for the January data, use that
rangename in a formula elsewhere, and then copy that
formula to the 11 columns to the right. But I don't want
to lock in the original rangename cell as an absolute
reference when I copy it. Lotus 123 has this flexibility
with rangenames, but it seems Excel does not. Am I just
missing this feature somewhere?

Art
 
Hi Art,

create your range name and the edit the refersto formula to remove the $
before the column reference.


Charles
______________________
Decision Models
FastExcel 2.1 now available
www.DecisionModels.com
 
Hi
AFAIK Excel does not have this feature. You could create some
workarounds using INDEX and a range name in combiantion
 
You must log in or register to reply here.

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

Confused with RangeName CellREfs 1
vlookup - choice of ranges 2
Referring to specific cell in named range in Excel formula 3
Calling worksheet-level names using insert Autotext in Word 3
union of RangeName 2
Finding Row Numbers Within the RangeName 4
Data Validation - using a list from another workbook 4
Consistent Sheet column header rows 2

Back
Top