Microsoft Office
Microsoft Office questions? Ask an IT Expert for support ASAP
Connect one-on-one with {0} who will answer your question
Answered in 20 minutes by:
3/7/2017
Bing, Senior IT Consultant
Category: Microsoft Office
Satisfied Customers: 8,173
Experience: Microsoft Certified Professional
VerifiedWhat is your specific requirement about Excel? To create something helping you save time in changing something?
How JustAnswer works
Describe your issueThe assistant will guide you
Chat 1:1 with a microsoft office technicianLicensed Experts are available 24/7
100% satisfaction guaranteeGet all the answers you need
Related Microsoft Office Questions
Word and embedded Excel problem. 2019. Running Windows 10 as
Word and embedded Excel problem JA: What version of Excel are you using? Customer: 2019 JA: Have you updated Excel recently? Customer: yes JA: Is there anything else the Microsoft Office Expert should… read more
Joseph
Computer Science
5,124 satisfied customers
My excel is not using current software. My computer is using
My excel is not using current software JA: What version of Excel are you using? Customer: my computer is using 2016 I own 2020 or 2021 JA: Have you updated Excel recently? Customer: yes JA: Is there a… read more
Shawn
IT Analyst / Consultant
Masters in Information Systems
8,739 satisfied customers
TROUBLE WITH A FORMULA, CAN YOU HELP? EXCEL. OFFICE 365
IM HAVING TROUBLE WITH A FORMULA, CAN YOU HELP? JA: What app are you using? Customer: EXCEL JA: Have you updated Excel recently? Customer: IM USING OFFICE 365 JA: Anything else you want the Microsoft … read more
Kaiser
Computer Engineer I
Bachelor of Science in Mechanical Engineering
2,889 satisfied customers
I am updating an excel sheet with an automation. It adds new
I am updating an excel sheet with an automation. It adds new data to the next empty row. I also need to have new employee numbers populate each row as information is added, so I created a function. Ho… read more
Pete
4,068 satisfied customers
Second opinion] I have microsoft excel and I received a note
Second opinion] I have microsoft excel and I received a note on my computer saying I needed to rebuy it and I have never had to rebuy the software in the past. Why now. My excel is not working, no cha… read more
Ricky
Tech Support Expert
Bachelor's Degree
10,634 satisfied customers
Essentially I need to do the following in excel: WHEN
Essentially I need to do the following in excel: WHEN Today=1/17/2019, change M25 cell value to F3, and DO NOT change it after … read more
The-PC-Guy
Computer Manager
Bachelor's Degree
877 satisfied customers
Wow. Overnight my all my work has disappeared. I had to
Wow. Overnight my all my work has disappeared. I had to reinstall Final Draft...which is my work software. My Excel spreadsheets are no where to be found.My banking account and business spreadsheets a… read more
YourITguy18
IT support Analyst
Associate of Applied Science
59 satisfied customers
This is a VERY advanced question that pertains to Google
This is a VERY advanced question that pertains to Google Sheets but perhaps someone with VERY advanced Excel knowledge can also answer it.I needed for my work to capture a time stamp without any scrip… read more
George Sibiya
PhD
392 satisfied customers
When closing out excel spreadsheet. It creates a temp folder
Hi Pearl, When closing out excel spreadsheet. It creates a temp folder on the network share where the excel spread sheet was opened … read more
Russell H.
Computer/Electronics Consultant
Vocational, Technical or Trade Scho
4,053 satisfied customers
I have an access program that builds an export file by
I have an access program that builds an export file by running 2 querries and summing the totals into an excel file....if an item is listed twice in the import file the quantities in the final export … read more
Richard
IT Manager
IT Manager, Consultant
23,368 satisfied customers
I was working on excel, and my mouse clicked SAVE. when I
I was working on excel, and my mouse clicked SAVE. when I returned to the spreadsheet, the whole thing had grayed out. I'm afraid to have lost all my information. … read more
Bing
Senior IT Consultant
8,173 satisfied customers
I need to return a value ignoring errors for the following
Hello! I need to return a value ignoring errors for the following formula =AVERAGE(SUBTOTAL(9,OFFSET('[Copy of KPI - 2016 (006).xls]Mark L.'!$K$1:$K$54,LARGE(IF('[Copy of KPI - 2016 (006).xls]Mark L.'… read more
Bruce Wilner
Master of Engineering
33 satisfied customers
I was working with an excel spreadsheet and i did the latest
I was working with an excel spreadsheet and i did the latest update to Excel 2016 for MAC. all of a sudden I am getting #NAME? errors. the file works fine on a PC but when I open on MAC i am getting a… read more
Bruce Wilner
Master of Engineering
33 satisfied customers
Currently I carry forward a balance from monthly file 2016-04
Currently I carry forward a balance from monthly file 2016-04 Bank Stmt.xlsx to file 2016-05 Bank Stmt.xlsx using cell contents 'F:\Bank Statements\[2016-04 Bank Stmt.xlsx]Main'!$P5 For next month I w… read more
Zabo04
Computer Enthusiast
Master's Degree
73 satisfied customers
I have the antique Excel 2003 version. Have question(s) about
I have the antique Excel 2003 version. Have question(s) about entering and maintaining various formats in a spreadsheet I use and update twice a week or so. An example would be the format for dates: I… read more
Miro
Computer Support Specialist
229 satisfied customers
You work for a local construction firm, "DeVry Engineering
You work for a local construction firm, "DeVry Engineering Group" and your supervisor wants to test your knowledge and skills with Microsoft Excel and has instructed you to develop a spreadsheet to ca… read more
The-PC-Guy
Computer Manager
Bachelor's Degree
877 satisfied customers
Hi. I have a spreadsheet, its quite basic. It is a summary
Hi. I have a spreadsheet, it's quite basic. It is a summary of sales for the previous week. What I would like to do is copy the spreadsheet 51 times so I have it for a whole year. I would like the for… read more
Jess
Bachelor's Degree
2,637 satisfied customers
I am working with MS Excel 2010. I want to update/filter
I am working with MS Excel 2010. I want to update/filter a pivot table based on a value inputted/selected from a validation list in another portion of the spreadsheet. How do I do this? I am not a pro… read more
John D
Bachelor Degree in Engineering
140 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.
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.
...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.
New York
Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.
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!!!!
Los 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.
Hesperia, CA
I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.
Kernersville, NC
Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around.
Woodstock, NY
Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.
Elkton, Maryland
< Previous | Next >
Meet the Experts:
The-PC-Guy
Computer Manager
877 satisfied customers
20 years experience providing remote computer support
Shefin
Microsoft Office Specialist
701 satisfied customers
Working as Tech support specialist with a world famous computer manufacturer
Miro
Computer Support Specialist
229 satisfied customers
Bachelor's Degree in Information Technology, Microsoft Certified Professional
Steve Herrod
Computer Support Specialist
132 satisfied customers
Trained in Microsoft Office from 2000 through to latest version 2010.
Zabo04
Computer Enthusiast
73 satisfied customers
Experienced in Word, Excel, Access, Powerpoint, and Outlook.
Travis
Computer Enthusiast
32 satisfied customers
I have 12 years of experience in the IT field.
Val B
Analyst / Trainer
31 satisfied customers
Expert in solving Microsoft Office problems.
< Previous | Next >
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.
