homework

  1. I

    Excel Solver add-in: unsure how to go about this question

    Excel Solver question: The University of Western Football Team has hired a dietician from a big name American school to develop a nutritious lunch menu for the team. After consulting with Canada’s Food Guide and other sources, the dietician has determined that each lunch serving should have...
  2. R

    Question regarding recommend PivotTable

    Hello everyone, My name is Ryan and I am new to the forum. I am fairly new to learning excel. I am currently enrolled in a class at Northern Virginia community college to help to become more familiar on how to use excel. I was wondering if anyone could help me to understand how recommend...
  3. F

    Large if returning name instead of value

    Because the heading is so clear! I have the following data: <tbody> A B C D E F H I J K UPN Name Year SEN Care FSM Subject Type Class Points 123 abc 7 S Y Y Geography Homework 7L4/Gg 1 456 def 7 Technology Homework 7L4/Te 1 678 ghi 8 S Y Science Disruption to Learning 8a/Sc3 2...
  4. F

    copy cell if two criteria match

    OK I have a table that looks something like this: <tbody> A B C D E F G H I J Surname Forename UPN Type Points Talking when the teachers talking Equipment Homework Disruption to Learning Attitude to Learning Aashir Muhammad DXxxx Talking when the teachers talking 1 DXxxx Equpment...
  5. R

    Macro to convert data to a more standard form?

    I'm not really sure how to explain this... basically I get reports on student grades for tests/projects on different dates. THe report that's generated can export to excel but it's not the easiest to work with. I'd like to make a macro to convert this data to a different format (Like student...
  6. M

    Questions about my Excel homework

    Hi! I study use of Excel in my university, but I've encountered insurmountable challenge in my latest homework. No previous teaching material or guidelines provide any kind of help in this task, and I wonder if someone with more brain than me can give a little hint where to start at least. I...
  7. E

    Percentages in excel

    I have been asked to carry out the following: "HIGHLIGHT WHAT TARGETS HAVE BEENHIT and WHAT IS THE GAP TO HITTING A TARGET I have data of what the sales target was supposed to be and what peoples individual targets were. How can i: 1. Bess display this is a graph. What graph is...
  8. F

    Homework help ICT/ if() function

    I must work sheet. Unfortunately I do not understand how to make some points. I translate below all points and I'll explain where I do not understand. 1. Open the application Microsoft Excel and save the current register in your document "football.xlsx". 2. Enter the first spreadsheet match...
  9. C

    Advanced Filter not doing what I want it to do.

    Hey, currently doing Slaying Excel Dragons homework problem 84 which involves using advanced filter. As you can see, I want to set the criteria to Jo OR Fred but the result is also including "Joe" which is Jo plus an "e". Why is excel doing this and how do I stop it?
  10. S

    User Form, Homework Help, VBA, will pay!!!

    If anyone can do this lab that is due Wednesday for me I will honestly paypal you $10. I know this is a breeze for most of you and I would typically try and knock it out myself but I have a Prob&Stats exam tomorrow and a Deterministic Exam Wednesday that I really need to focus on and have no...
  11. P

    Sub for currency converter

    SO I HAVE THREE COLUMNS THE ONE WHICH TELL ME THE CURRENCY, THE ONE THE PRICE IN THAT CURRENCY ANF FINALLY THE ONE WITH THE ASJUSTED PRICE( WHICH IS MY OUTPUT) NOW IF THE THE CURRENCY IS "peso" the output is the same as the second row (price), if the currency is dolar. (price) must be...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top