Solved

more efficient way to put a group cells in a named field  - Excel 2010

Posted on 2013-11-18
2
205 Views
Last Modified: 2013-11-18
Experts,

I am listing a group of columns to be used a in a calcuation.  The columns are:

$C$13, $C$17, $C$21, $C$25,$C$29,$C$33.........$C$69

Is there a more efficient way to list these fields other than individually in a named field?  They are four rows apart.

I will be using the values of these rows in calculations and I am hoping not to have to repeat the set each time.
0
Comment
Question by:morinia
2 Comments
 
LVL 23

Assisted Solution

by:NBVC
NBVC earned 100 total points
ID: 39657733
You select the cells, then enter the name in the NameBox just to the left of the Formula Bar at the top.
0
 
LVL 8

Accepted Solution

by:
stevepcguy earned 250 total points
ID: 39657784
1. Select all the cells by holding down the CTRL key, and clicking on each cell.
2. Name the range of cells by typing the name in the name box. The name box should show the last cell you clicked on. Just click in the box, type the name you would like to give this range, then press ENTER.

If you give the range a name like "MidYearTotals", you can use that term in formulas, etc:

=Average(MidYearTotals)

for example.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…
Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question