help a student

  1. C

    Time Value Distribution Automated?

    Hi all, I am new to this so bare with me. Below is the current solution to my predicament, done manually. I would like to automate the distribution column. For this, the numerator is the TVU column, and the denominator is determined via the COUNTIF() function. The issue is that I cannot get...
  2. A

    Need help with either Conditional formula or VBA script to solve issue

    Hello I am having an issue figuring out how to get my duty excel spreadsheet to do the below and am looking for either a formula or VBA based solution: Basically I have the below spreadsheet and if there is a value in the additional duty column (starting at I5) I would like the value to be...
  3. A

    VLOOKUP and return complete row but with certain conditions

    Hi, I am new to the forums and I need some help please I have several rows where a specific Event ID (Column A) occurs multiple times. What I want to do is have all the key information on just 1 row without having the Event ID being displayed on multiple rows. As shown in the attached image...
  4. 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...
  5. A

    Array formula for unique dates for specific names

    Hello, I am trying to count the number of unique dates between 1/1/2018 and 12/31/2019 for specific Well names. For example, Well Name (29-6 64N) has 5 rows of dates in which 4 of those are unique and the other is repeated. Is there a way to count how many dates are unique for each Well Name...
  6. A

    Need help with creating all the possible combinations from the table.

    after researching..i couldnt really come up with much results which is why im posting here. 1] is it possible to make out combinations with the given data? 2] also, i have to make sure that when it is combined, the total =10 not more or less Here's the data: <tbody> a b c d e f g h i o p q r...
    • alk3yn
    • Thread
    • help ! help a student need answer please help me problem
    • Replies: 12
    • Forum: Excel Questions
  7. H

    Help a student

    Hi Guys, I'm currently at college, and on my new course, we have started a module that goes over spreadsheets. As I am very new to using spreadsheets, would it be possible if anyone could give me any guidance on completing this task? I will attach a dropbox link for you to view the question...

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
Back
Top