Programming

Programming Questions? Ask a Programmer for Answers ASAP

Ask a Computer Expert,
Get an Answer ASAP!

Programming

Am I able to send you the spreadsheet I am working on?

Customer Question
Am I able to send you the spreadsheet I am working on?
Submitted: 1 year ago.Category: Programming
Ask Your Own Programming Question
Customer reply replied 1 year ago
that you can help me write a formula or help me determine if a macro is necessary?
Answered in 1 hour by:
6/7/2016
Programmer: Bryan, Programming Tutor replied 1 year ago
Bryan
Bryan, Programming Tutor
Category: Programming
Satisfied Customers: 1,445
Experience: Delphi, c, c++, c# and even a bit of Assembler thrown in. I've been programming for over 25 years. What do you need to know
Verified

Sure. Just attach it using the paperclip icon. Then you can explain what it is that you are trying to do.

Ask Your Own Programming Question
Customer reply replied 1 year ago
sorry for the delay
Programmer: Bryan, Programming Tutor replied 1 year ago

No problem. Go ahead and explain what you are trying to do while I take a look.

Ask Your Own Programming Question
Customer reply replied 1 year ago
ok. column L has formulas written. because there are spaces, I can't sort properly or at all. I need to find all the results (yes, no, and #sum) and list the column A, H, I, J next to those results in ascending order on a separate tab and be able to sort. Or if there is an easier way, I am open.
Programmer: Bryan, Programming Tutor replied 1 year ago

Alright. Give me a minute.

Ask Your Own Programming Question
Customer reply replied 1 year ago
maybe a Vlookup?
Customer reply replied 1 year ago
I can't give up the spaces between players because of the formulas in column I. We will be adding scores as the season goes on.
Programmer: Bryan, Programming Tutor replied 1 year ago

Ok, well first we need to fix the errors on I and J, then we can fix L. How quickly do you need this done?

Ask Your Own Programming Question
Customer reply replied 1 year ago
what errors are you referring to? the formulas in H require 3 scores, and if there are not 3 scores, I am ok with the result "#sum"
time frame- tomorrow or Thursday will be fine. What am I dealing with here-- formulas or macros? Thanks- DA
Customer reply replied 1 year ago
Sorry--- the formulas in I require 3 scores, Not H
Programmer: Bryan, Programming Tutor replied 1 year ago

This can all be done with Formulas. I am getting #NUM calculation errors that I need to fix before I can work on the L calculation. Which version of Excel are you using? Or are you using a different spreadsheet app than Excel? I can get to work on this and should have it for you sometime within the next 12-18 hours.

Ask Your Own Programming Question
Customer reply replied 1 year ago
I am unsure of the excel version I am using. probably 2000.
If any player does not have three scores, I would prefer a result of "not enough scores" or "#sum" is fine too.
If you think my formulas throughout the sheet are not adequate I am open to that.
This sheet attempts to calculate player's best three scores (and differential as shown in the formula), and which player's best three as compared to their GHIN handicap which is a manual entry, not a formula. Thanks-
Programmer: Bryan, Programming Tutor replied 1 year ago

Ok. That could be why I am getting an invalid number calculation on those columns. I will need to install Office 2000 to verify that. Are you using Windows for this? And if so, do you know which version?

Ask Your Own Programming Question
Customer reply replied 1 year ago
Microsoft office version 2010 plus.
Operating system is windows but can't figure out which version. I'll keep looking.
Customer reply replied 1 year ago
Just found it. Windows 7 Enterprise.
Programmer: Bryan, Programming Tutor replied 1 year ago

Ok. I'm running Office 2013 in Windows 7 Pro. I'll install 2010 to make sure we keep compatibility. I'll have something for you tomorrow (12-18 hours from now).

Ask Your Own Programming Question
Programmer: Bryan, Programming Tutor replied 1 year ago

Can you send me a sheet with a full set of rows? Or at the very least 9 rows? Does col I look correct in your set of data? How about col J?

Ask Your Own Programming Question
Customer reply replied 1 year ago
I will have to send this later.
i am unsure why you need a full sheet with at least 9 columns. Thx. DA.
Programmer: Bryan, Programming Tutor replied 1 year ago

My request for the extra data has to do with the Average function used in Col I, which in turn affects Col J. Which is also my reason for asking about those Columns.

Ask Your Own Programming Question
Programmer: Bryan, Programming Tutor replied 1 year ago

What is Column I supposed to represent? And how does it change based on subsequent rows? I just filled in fake values for G8 (11.6) and G9 (11.7) to get the Small calculations to work (since you are trying to retrieve 3 values, it needs at least 3 values to work with. I could have used any other 2 rows in G, I just chose those two because they were there). The Average of those will always be 11.6 (just because of the fake values I put in). So depending on how the formula changes for subsequent rows, it will either stay 11.6 in col I for all rows, or it will differ if you average other cells.

Then we come to Column J. I'm not sure why you are using =SMALL(I7:I7,1) because it's not an array that is stored in I, just an average of the 3 Small values. You could have just as easily used =I7

However, once I put in the fake data, I got rid of the #NUM error in I and J plus got a "No" in L

So that's why it would be best to have more data and an explanation of what the data should look like in Cols I and J. Once we get those worked out, then we can move on to your original problem.

Ask Your Own Programming Question
Customer reply replied 1 year ago
I see. Thx for the elaboration. Entering fake values to eliminate the #SUM results is fine because as I add more scores, I will override your fake entries anyway.
I will look into col J. The formula should have been looking at column H and I, not just I. I will let you know when I can get back to a computer. Might have to be after work later today.
Programmer: Bryan, Programming Tutor replied 1 year ago

That's fine. Just let me know when you're ready to continue.

Ask Your Own Programming Question
Programmer: Bryan, Programming Tutor replied 1 year ago

Did you still want to work on this, or have you found another solution?

Ask Your Own Programming Question
Ask Bryan Your Own Question
Bryan
Bryan
Bryan, Programming Tutor
Category: Programming
Satisfied Customers: 1,445
1,445 Satisfied Customers
Experience: Delphi, c, c++, c# and even a bit of Assembler thrown in. I've been programming for over 25 years. What do you need to know

Bryan 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

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

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.

EstherWoodstock, 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.

RobinElkton, Maryland

< Previous | Next >

Meet the Experts:

ATLPROG

ATLPROG

Computer Software Engineer

7,677 satisfied customers

MS in IT.Several years of programming experience in Java C++ C C# Python VB Javascript HTML

LogicPro

LogicPro

Computer Software Engineer

7,109 satisfied customers

Expert in C, C++, Java, DOT NET, Python, HTML, Javascript, Design.

unvadim

unvadim

Computer Software Engineer

1,168 satisfied customers

Good knowledge of OOP principles. 3+ years of programming experience with Java and C++. Sun Certified Java Programmer 5.0.

lifesaver

lifesaver

Computer Software Engineer

950 satisfied customers

Several years of intensive programming and application development experience in various platforms.

ehabtutor

ehabtutor

Computer Software Engineer

936 satisfied customers

Bachelor of computer science, 5+ years experience in software development, software company owner

TheDoctor

TheDoctor

Software Engineer

893 satisfied customers

M.S. in Internet Information Systems

The-PC-Guy

The-PC-Guy

Software Engineer

789 satisfied customers

Extensive Knowledge in PHP, MYSQL, CSS & Javascript

< Previous | Next >

Related Programming Questions
I can't open an existing excel spread sheet from the file
I can't open an existing excel spread sheet from the file itself. I have to open excel first then select the file to see the data. I'm unable to do a mail merge to word by selecting the data file. I h… read more
robert
robert
Bachelor's Degree
2,594 satisfied customers
How do I write this formula correctly in excel? Excel 2010
Hello Pearl How do I write this formula correctly in excel? … read more
The-PC-Guy
The-PC-Guy
Software Engineer
Bachelor's Degree
789 satisfied customers
I need Excel help that is advanced in nature... In Excel, I
Hello, I need Excel help that is advanced in nature... … read more
The-PC-Guy
The-PC-Guy
Software Engineer
Bachelor's Degree
789 satisfied customers
I have an Excel question how does this work? Excel 2010. I
I need a formula but it would be easier to show you what I need rather than trying to explain it is there a way I can do that? … read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,208 satisfied customers
Do you know PowerPivot for Excel? Office 2013 for now, I
Office 2013 for now, I have a 2016 license as well … read more
Kris R
Kris R
IT Manager
Computing
2,263 satisfied customers
Changed formatting resets every time excel is opened. Excel
changed formatting resets every time excel is opened … read more
R LAFAYETTE
R LAFAYETTE
Intel Technology Provider 2017 GOLD
29 satisfied customers
We have a schedule (excel/VBA) that was created by a person
we have a schedule (excel/VBA) that was created by a person no longer at our company. It has multiply tabs and at the time it worked great. Now we need to add product however it does not have the simp… read more
George Sibiya
George Sibiya
PhD
194 satisfied customers
I just have one question on excel. Excel 2016. I need some
HI I just have one question on excel JA: What programs and versions are you using? Customer: excel 2016 JA: What is your ideal outcome? How can we solve this for you? Customer: I need some tip tips st… read more
David L.
David L.
Bachelor\u0027s Degree
6 satisfied customers
I need some help with an excel formula. Microsoft excel
I trying to use an index and match function using three criteria to pull a value off of a chart … read more
The-PC-Guy
The-PC-Guy
Software Engineer
Bachelor's Degree
789 satisfied customers
I know that Excel is a math based program. Is there a way to
I know that Excel is a math based program. Is there a way to learn it with limited math skills? … read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,208 satisfied customers
I have Excel 2017 on my computer. I just learned that this
I have Excel 2017 on my computer. I just learned that this "newer" MS excel version will not read/update a .xls file ( from pre-2003 excel). So, I want to convert a .xls file to .sxls file , everythin… read more
George Sibiya
George Sibiya
PhD
194 satisfied customers
I need help with excel function. Excel 2013. I have a math
i have a math problem and i have been posting in many sites … read more
John Lohr
John Lohr
Owner / Technology Specialist
Teaching Certification
379 satisfied customers
When accessing Excel, I receive the following message:
When accessing Excel, I receive the following message: "Microsoft Office cannot verify the license for this product." I cannot get past this message. What do I need to do. … read more
Bryan
Bryan
IT Consultant
8,745 satisfied customers
I am on Windows 7. At times either google chrome, adobe, or
I am on Windows 7. At times either google chrome, adobe, or excel will stop running while I am using them. I received a message stating the "saver screen" had stopped working. How do I correct this pr… read more
Josh
Josh
It Support Specialist
Associate Degree
5,127 satisfied customers
I cannot use save as in Excel. It sends a message of Excel
Hi, I cannot use save as in Excel. It sends a message of Excel is not responding and then I have to restart the program. … read more
Shefin
Shefin
Technical Support Executive
Engineering Diploma
218 satisfied customers
It's an excel question. Microsoft Excel Office 2016, I am
I am having trouble creating a formula and I am unsure how to go about it. The formula help within Excel is not understanding my question. … read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,208 satisfied customers
Excel is not responding and will not open, Office 365 2016,
Excel is not responding and will not open JA: What programs and versions are you using? Customer: Office 365 2016 JA: What is your ideal outcome? How can we solve this for you? Customer: how can I get… read more
Cody
Cody
Computer Science
1,462 satisfied customers
It is an Excel question.. 2010, Microsoft Office, I am
I am looking for assistance in figuring out a formula for a report… read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,208 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