Computer

For Online Computer Support, Ask a Computer Technician

Ask a Computer Expert,
Get an Answer ASAP!

Pivot Function How do I select data in a spreadsheet by specific…

Customer Question
Pivot Function: How do I select...
Pivot Function:
How do I select data in a spreadsheet by "specific year" or by the "name of a product" to insert in a pivot table?
Submitted: 8 years ago.Category: Computer
Show More
Show Less
Ask Your Own Computer Question
Answered in 5 minutes by:
6/29/2010
Tech Support Specialist: Dragonfly, Computer Support Specialist replied 8 years ago
Dragonfly
Dragonfly, Computer Support Specialist
Category: Computer
Satisfied Customers: 315
Experience: CCNA with years of experience in pc and network TS. Write programs in different languages
Verified

Hi,

 

My name isXXXXX will Try to help you with this query,

 

Which Office version are you using and could you share the file where an example could be shown?

Ask Your Own Computer Question
Customer reply replied 8 years ago
I am a librarian tracking journals used by researchers at my library. Journal names and publication dates have been entered into a spreadsheet for each occurance of use. I need to know the number of times specific journal titles have been used. I will also need to track the use of journals by ages. I am working within a 2004 to 2008 publication range.

Christine
Tech Support Specialist: Dragonfly, Computer Support Specialist replied 8 years ago

Thanks for the info Christine,

 

would it be possible for you to upload the spreadsheet so that I can have a look at it and give you the best possible way to solve your problem? Also are you working with office 2003 or 2007

Ask Your Own Computer Question
Tech Support Specialist: Dragonfly, Computer Support Specialist replied 8 years ago

I have made an example file for you

 

The "Data" sheet has all the data, The name column in the "Data"sheet could be compared to the Journal name. and the Pivot is on the sheet called "Pivot" on this sheet you could filter the results by clicking and selecting the name filter on the top. lemme know if you need more help on this

Ask Your Own Computer Question
Tech Support Specialist: Dragonfly, Computer Support Specialist replied 8 years ago

here is the link to download the file

 

http://www.sendbigfiles.com/a55c52dffc8b8747f4475e1c2866dd7a

 

Ask Your Own Computer Question
Was this answer helpful?

How JustAnswer works

step-image
Describe your issueThe assistant will guide you
step-image
Chat 1:1 with a tech support specialistLicensed Experts are available 24/7
step-image
100% satisfaction guaranteeGet all the answers you need
Ask Dragonfly Your Own Question
Dragonfly
Dragonfly
Dragonfly, Computer Support Specialist
Category: Computer
Satisfied Customers: 315
315 Satisfied Customers
Experience: CCNA with years of experience in pc and network TS. Write programs in different languages

Dragonfly is online now

A new question is answered every 9 seconds

How JustAnswer works:

  • Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction GuaranteeRate the answer you receive.

JustAnswer in the News:

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

What Customers are Saying:

My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed.

One Happy CustomerNew York

I am very happy with my very fast response. Eric is very knowledgeable in the subject area. Thank you!

RPAustin, TX

Hi John, Thank you for your expertise and, more important, for your kindness because they make me, almost, look forward to my next computer problem. After the next problem comes, I'll be delighted to correspond again with you. I'm told that I excel at programing. But system administration has never been one of my talents. So it's great to have an expert to rely on when the computer decides to stump me. God bless, Bill

Bill M.Schenectady, New York

The Expert answered my Mac question and was patient. He answered in a thorough and timely manner, keeping the response on a level that could understand. Thank you!

FrankCanada

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

GPHesperia, CA

< Previous | Next >

Meet the Experts:

Andy

Andy

Computer Consultant

5,316 satisfied customers

11yr exp, Comp Engg, Internet expert, Web developer, SEO

Engineer John C.

Engineer John C.

Computer Science Engineer

3,229 satisfied customers

Computer Science Engineer with 10 years of experience in Computer Support, and Microsoft, A+ and Cisco certified

Ryan H.

Ryan H.

Computer Support Specialist

1,741 satisfied customers

A+ Certified Technician - 10 Years experience working with all types of computer systems.

Jane Lefler

Jane Lefler

Sr Prog Analyst / Technician

2 satisfied customers

Computer Programmer / Technician/ Consultant 16+ years

Frederick S.

Frederick S.

Computer Specialist

7,241 satisfied customers

Computer technician and founder of a home PC repair company.

lifesaver

lifesaver

Computer Software Engineer

4,288 satisfied customers

Engineering degree in Computer science,Microsoft Certified Professional.JA computer expert.

Sudipto

Sudipto

Hardware Engineer

4,260 satisfied customers

Certificate Course In Computer Maintenance

< Previous | Next >

Related Computer Questions
i have a data source worksheet in my excel workbook and all
i have a data source worksheet in my excel workbook and all is working well with connections, however I've added a count of names (ie customers, employees) to the data source, however they are not upd… read more
Wei C.
Wei C.
Bachelor\u0027s Degree
979 satisfied customers
Having problem with embedded spread sheets in word documents.
Having problem with embedded spread sheets in word documents. I am using windows 7 microsoft word 2010 and microsoft excel 2010. When you open a new word document and insert a new embedded excel sprea… read more
Noisebox
Noisebox
High School or GED
2 satisfied customers
I have Office 2007 and am aware of being able to change the
I have Office 2007 and am aware of being able to change the Pivot table options > Display tab > Classic Pivot table layout but that does not completely meet my needs. I like the 2003 formatting … read more
Wei C.
Wei C.
Bachelor\u0027s Degree
979 satisfied customers
Our company has recently upgrade to Excel 2007. While working
Our company has recently upgrade to Excel 2007. While working with pivot tables, I notice that I sometimes seem to be missing the borders in the pivot table, which usually are automatically inserted (… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
hi, microsoft excel, pivot table, calculated field/item question.
hi, microsoft excel, pivot table, calculated field/item question... 1. i created a calc item (on a calculated field) and when i subtract one from the pivot table gives an incorrect answer 2. i created… read more
Pete
Pete
Engineer
Bachelor\u0027s Degree
1,131 satisfied customers
Pivot Table Help Needed - I need help adding calculated fields
Pivot Table Help Needed - I need help adding calculated fields to a pivot table so it updates automatically. I've created the pivot table - just need help adding var ($ & %) for particular rows - and … read more
NY Eng
NY Eng
Control Systems Engineer
Bachelor\u0027s Degree
19 satisfied customers
how do i take data from an excel pivot table and reference
how do i take data from an excel pivot table and reference it to populate a field in a worksheet?… read more
Jack
Jack
Sr. Engineer
Bachelor\u0027s Degree
123 satisfied customers
I have a large excel spreadsheet (20,000 rows) of customers
I have a large excel spreadsheet (20,000 rows) of customers with many duplicates (sorted by a customer number). I want to consolidate the data located in a variety of rows into 1 row for each customer… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
Im trying to create a PivotTable in Excel 2007, but the Field
I'm trying to create a PivotTable in Excel 2007, but the Field List doesn't appear on the screen, therefore I can't select the fields (headers). I've tried the toggle button for 'Show Field List' but … read more
LeGin
LeGin
Unit Manager
Bachelor\u0027s Degree
13 satisfied customers
EXCEL 2007 PIVOT TABLE COPIED BASE FILED WITH GROUP COMMAND
EXCEL 2007 PIVOT TABLE COPIED BASE FILED WITH GROUP COMMAND AND WAS ABLE TO RETAIN SEPERATE SUB FIELDS...NOT THE TYPCIAL "GROUP HEADING"...DID THIS ABOUT A YEAR AGO AND CAN NOT RECREATE. IT APPEARS OU… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
I am trying to link 2 pivot tables, both on separate sheets
I am trying to link 2 pivot tables, both on separate sheets with the exact same categories. I want to be able to change both drop down categories at the same time so I can populate a chart with data a… read more
Networking101
Networking101
Network/Security Administrator
Bachelor's Degree
422 satisfied customers
the pivot table functionality in the 2007 version of excel
the pivot table functionality in the 2007 version of excel has changed from the prior version . It seems i cannot actually "pivot" the data (like the prior version). There are no drop down arrows (rep… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
I Have an excel spreadhseet open with a number of rows that
I Have an excel spreadhseet open with a number of rows that i need to group together and name so that other people can see what the information is withouh having to open each group. I haven't been abl… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
How do I add a formula column in an Excel pivot table
How do you add a formula column based on the existing columns in the data table. I do not want to add the new column in the dataset table just in the Pivot table layout.… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
I have an assignment to do in excel, which has to include ...
I have an assignment to do in excel, which has to include some of the following:- Macro (which somebody has very kindly sorted for me), Data validation, combination chart, secondary axis, trendlines, … read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
How do you get the cell reference of the last row of a ...
How do you get the cell reference of the last row of a pivot range so I can use it in a formulae. (The assumption is the Pivot Range is not static, hence the "Grand Total" Row may be in row 12 but whe… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
I need to integrate data from 2 separate databases. If ...
I need to integrate data from 2 separate databases. If one spreadsheet has data in one format and the other has data in another format and I need them to come together. I have seen this done with VLoo… read more
the prof
the prof
computing consultant
Master's Degree
160 satisfied customers
I created a pivot table in MS Excel; (I can attach the ...
I created a pivot table in MS Excel; (I can attach the file) anyway, my subtotal columns are adding percentages, which I don't want. I can't insert a calculation into the spreadsheet. Can anyone help … read more
Kraig Grayson
Kraig Grayson
CEO/Webmaster
Diploma (Honours)
138 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less

Ask Your Question

x