[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

google docs spreadsheet

Posted on 2013-05-15
2
Medium Priority
?
294 Views
Last Modified: 2013-05-15
I know I can name a range in google docs spreadsheet.  How do I access a single element of the named range?  My range is named "AGE" and is A4:A60.
0
Comment
Question by:dwcronin
2 Comments
 
LVL 43

Accepted Solution

by:
Saqib Husain, Syed earned 2000 total points
ID: 39169316
=index(age,2)

will give the 2nd element of the list
0
 

Author Comment

by:dwcronin
ID: 39169578
thank you!!!!!!  I'm embarrassed to say how long I've had that problem
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Ever wonder what it's like to get hit by ransomware? "Tom" gives you all the dirty details first-hand – and conveys the hard lessons his company learned in the aftermath.
Quickbooks hosting can do wonders to your enterprise but considering the points elaborated in the article which will help you to better analyze the outcomes. So scan your business, its needs and then move to the new world of limitless benefits.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

834 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