Mac

Ask Mac Questions and Get Answers from Experts ASAP

Ask a Computer Expert,
Get an Answer ASAP!

Mac

I have a spreadsheet with all yearly data broken down by each

Customer Question
month. I need to show show...
I have a spreadsheet with all yearly data broken down by each month.

I need to show show data in a table by Current Month, Current Quarter, and Year to Date in 6 different categories so I can graph it. (This data needs to change automatically based on the current month.) I'm using Excel 2011 for Mac.
[email protected]
XXX-XXX-XXXX
Submitted: 7 years ago.Category: Mac
Show More
Show Less
Ask Your Own Mac Question
Answered in 2 minutes by:
12/22/2010
Mac Support Specialist: John D, BS Degree in Engineering replied 7 years ago
John D
John D, BS Degree in Engineering
Category: Mac
Satisfied Customers: 9,666
Experience: Worked on Macs and PC's for 20+ years.
Verified

Hi,

 

Could you please send me the file so I can take a look at it (let me know if you are not familiar with sending files on this site)

 

Ask Your Own Mac Question
Customer reply replied 7 years ago
How do I send the file as an attachment
[email protected]
Mac Support Specialist: John D, BS Degree in Engineering replied 7 years ago

Ok, go to www.wikisend.com and upload the file there (no need to sign up). You will then get a page that has the download link and File ID. Copy the download link or the File ID and come back here and paste it in your reply.

 

Please make sure you identify the cells in question and where you want the formulas or result to be placed

 

 

Ask Your Own Mac Question
Customer reply replied 7 years ago
John this may take a few minutes to complete. The data is highly confidential, so I need to sanitized it first.
[email protected]
Mac Support Specialist: John D, BS Degree in Engineering replied 7 years ago

Sure, take your time

 

 

Ask Your Own Mac Question
Customer reply replied 7 years ago
Look at Row: 60 to 68, Columns B and E thru I ------ original data is above above Row 60 and we are looking at the GAIN % columns only for each month

Row 62 should come from Row 57
Row 63 should come from Row 52
Row 64 should come from Row 53
Row 65 should come from Row 47
Row 66 should come from Row 46
Row 67 should come from Row 49
Row 68 should come from Row 48

link on Wiki is: http://wikisend.com/download/451380/test copy for support.xlsx
Customer reply replied 7 years ago
John, I've sent you the file and other info you requested and not sure it is going thru to you?
[email protected]
Mac Support Specialist: John D, BS Degree in Engineering replied 7 years ago

Yes I got the file and I am looking at it now

 

It is clear which row is coming from which row, but what data will each cell in the row pull from the other row? Say E63 and F63, what will they pull from row 52

 

 

 

 

Ask Your Own Mac Question
Customer reply replied 7 years ago
Lets look at cell E62 (Current Month column) and assuming it is Jan therefore the data would automatically come from Jan GAIN % (column G). The data would therefore be coming from cell G57

Did I answer your question?
[email protected]
Mac Support Specialist: John D, BS Degree in Engineering replied 7 years ago

Not fully. I gave two examples. Quarter? would that be current quarter, which is month 1 thru 3?

 

 

 



Edited by John D on 12/22/2010 at 8:02 PM EST
John D
John D, BS Degree in Engineering
Category: Mac
Satisfied Customers: 9,666
Experience: Worked on Macs and PC's for 20+ years.
Verified
John D and 87 other Mac Specialists are ready to help you
Ask your own question now
Customer reply replied 7 years ago
The Quarter column should also generate the answer based on the 1Quarter, 2Quarter etc based on the end of that Quarter of the the year. For instance if it is April 1 it would generate the it's data from cells G57, I57, and K57 averaged.

Then it would change to cover the 2Quarter months of April, May, June (GAIN %) cells
[email protected]
Mac Support Specialist: John D, BS Degree in Engineering replied 7 years ago

Thanks I think it is clear for the most part (where does '2 year data' come from if there are only 13 months)?. That means 35 unique formulas are needed none of which can be simply copied and pasted to another cell. If it were one or two unique formulas I would be happy to write them for you. Under the circumstances I am going to opt out so the question becomes open to all experts. The clarification that you provided will be available and will certainly help the other experts

 

 

 

 

 

Ask Your Own Mac Question
Mac Support Specialist: John D, BS Degree in Engineering replied 7 years ago

Thanks. I guess I will have to continue assisting with this. Not a problem, I will set up a few formulas and send them out to you for your review, then we will take it from there.

 

 

 

Ask Your Own Mac Question
Customer reply replied 7 years ago
John, the idea is to have up-to-date data based on the end of last month's figures that I could put in a graph to quickly get a snapshot and comparison. The 2 year data I don't need to worry about right now since I don't have 2 yrs of data to work from yet.

It has also been suggested to me that this would be ideal for a Pivot Table. But it's been so long since I've done one I'm totally lost in trying to accomplish that as well.

I accepted your last response thinking that it would let you know that I was still on this end. I really would like to get some resolution on this issue and additional help.

I do thank you for your effort and time! 35 formulas is unreasonable!

Lee A. Jones [email protected]
XXX-XXX-XXXX
Mac Support Specialist: John D, BS Degree in Engineering replied 7 years ago

Ok here are most of the formulas (except for the 2-Yr part). As you will notice I had to use some helper columns (BA through BF) to hold some transitional formulas.

 

http://wikisend.com/download/411718/Test%20copy%20for%20tech%20support%201.xlsx

 

Hope this is ok

 

Ask Your Own Mac Question
Ask John D Your Own Question
John D
John D
John D, BS Degree in Engineering
Category: Mac
Satisfied Customers: 9,666
9,666 Satisfied Customers
Experience: Worked on Macs and PC's for 20+ years.

John D 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:

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

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

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

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

JustinKernersville, NC

< Previous | Next >

Meet the Experts:

Mike

Mike

Mac Medic

8,555 satisfied customers

Over 20 years IT experience with Apple computers in publishing, marketing and design.

Daniel

Daniel

Mac Genius

4,711 satisfied customers

Apple certified on desktop and portable, help desk qualified. Have owned and used Macs since 1989.

Vinod Menon

Vinod Menon

Support Specialist

2,394 satisfied customers

worked as a Tech support Associate for Apple products

John T. F.

John T. F.

Mac Druid

1,994 satisfied customers

20+ years in the computer/Mac industry

David

David

Mac Support Specialist

1,507 satisfied customers

BSc H.Dip Apple Certified Professional

Claws224

Claws224

IEEE Datacommunication Engineer

965 satisfied customers

IEEE, Microsoft

Mac Tech

Mac Tech

Apple Specialist

888 satisfied customers

7 + Years Supporting Apple Products

< Previous | Next >

Related Mac Questions
I have Microsoft office for apple (Mac). I deleted excel and
I have Microsoft office for apple (Mac). I deleted excel and power point, how do I get em back? … read more
Ashik
Ashik
Master\u0027s Degree
5,097 satisfied customers
I have an Excel workbook that opens extremely slow. What can
I have an Excel workbook that opens extremely slow. What can I do to speed it up? Thank you. … read more
Justin Johnson
Justin Johnson
Training and Development Contractor
1,016 satisfied customers
I have a Mac with Microsoft ( word, powerpoint Excell and
I have a Mac with Microsoft ( word, powerpoint Excell and Outlook)I need to upgrade to outlook 2016. I am having problems as I don't remember my microsoft log in password Help … read more
Ashik
Ashik
Master\u0027s Degree
5,097 satisfied customers
I just purchased the excel-etal. I can't get excel to open.
I just purchased the excel-etal. I can't get excel to open … read more
Justin Johnson
Justin Johnson
Training and Development Contractor
1,016 satisfied customers
I had to update my Word and Excel recently and I have had
I had to update my Word and Excel recently and I have had nothing but problems every since. I can't Save As two different Excel docs. I try to close them and I get a whirling wheel and "Refreshing" wh… read more
Josh
Josh
It Support Specialist
Associate Degree
5,138 satisfied customers
Microsoft office outlook and excel and word will not open, i
microsoft office outlook and excel and word will not open, i get the message this application will not open correctly with a code Oxc0000142. what must I do to correct ? … read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,269 satisfied customers
I sent my wife and Excell file but we only have access to
I sent my wife and Excell file but we only have access to Mac computer so need to know how to convert it into pages to be able to open it on a MacBook pro … read more
Michelle
Michelle
Manager operations
Bachelor\u0027s Degree
1,275 satisfied customers
I have been using the microsoft one cloud/ excel and word
I have been using the microsoft one cloud/ excel and word apps on my apple Ipad. it is telling me (after two years use) that it can not connect with the internet. Meanwhile all my other apps can? … read more
Justin Johnson
Justin Johnson
Training and Development Contractor
1,016 satisfied customers
Can I back out an upgrade to Excel without losing files? OS
Can I back out an upgrade to Excel without losing files? … read more
Ashik
Ashik
Master\u0027s Degree
5,097 satisfied customers
I am trying to understand why the Mail merge from Excel to
I am trying to understand why the Mail merge from Excel to Word will not work on my brand new computer??? The excel is saved in the format ".xlsx" but it still says I need an Excel Workbook Text Cover… read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,269 satisfied customers
I just this afternoon updated microsoft office excel but I
I just this afternoon updated microsoft office excel but I don't want it now. I have a backup external hard drive. can i get rid of the update by downloading from time machine. if so, how? … read more
Justin Johnson
Justin Johnson
Training and Development Contractor
1,016 satisfied customers
I am trying to save updates to an excel spreadsheet on my
I am trying to save updates to an excel spreadsheet on my new 27" Mac that I brought in from a 10 year old Mac. I get a "something went wrong" massage, which recommended that I contact you. … read more
Cabletech
Cabletech
High School or GED
140 satisfied customers
I've used Excel for years with no problems. I have a new
I've used Excel for years with no problems. I have a new iMac desktop with a more current OS and Excel version than I have been using. … read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,269 satisfied customers
I guess I need to update my Excel but not sure how to do it.
I guess I need to update my Excel but not sure how to do it … read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,269 satisfied customers
Excel for Mac opens to a blank Excel file, When I bought the
When Excel opens to a blank file, it also freezes my machine from doing other things, such as logging out, restarting, etc. I've done a forced shutdown (holding down the power button), but this hasn't helped. Same problem exists once I restart the machine. … read more
Russell H.
Russell H.
computer technology consultant
Vocational, Technical or Trade Scho
780 satisfied customers
Im on my moms computer trying to help her. Her excel program
Im on my moms computer trying to help her. Her excel program is not working and will not open at all. I have the original Office.mac dvd but dont know how to reinstall excel without losing whatever da… read more
Ashik
Ashik
Master\u0027s Degree
5,097 satisfied customers
Hanging with Word and Excel - just did updates. No idea. It
It is a Mac mini, i7 with 16 mb ram purchased in 2013, it should be running the latest Mac OS … read more
Ashik
Ashik
Master\u0027s Degree
5,097 satisfied customers
Excel for Mac. The tabs at the bottom of the page have
Excel for Mac. The tabs at the bottom of the page have disappeared. Tried changing preferences as suggested and no change.Thanks.… read more
Jon
Jon
Bachelors Degree
479 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