component

  1. russkris

    SUMIFS help with multiple criteria

    Hi, I have a project with a limited budget however one component is not included in the budget but still need to keep track of the cost. The project has 6 components and each component has Normal cost and overtime cost. This is the sheet supervisors are filling out [Table1]-[Table30] and...
  2. N

    Pulling my hair out trying to get a formula to work (or do ANYTHING)

    Hi all, I'm trying to work out the distance between two sets of lat/long coords. After much searching I found the formula at the bottom When I use it with either numbers instead of lat/longs or the cell reference my PC does absolutely nothing. It doesn't post anything in the cell at all, not...
  3. O

    Calculating wind speed from 3 components (U, V, and W)

    Hello all, I am having an issue! I have a 3D sonic anemometer, and this is the first time I deal with it. I did a small experiment to collect some data. The output was U, V, and W for every 0.3 second. I have a huge excel sheet of data, and I don't know how to measure wind speed and direction...
  4. J

    Recipe tracker

    To make the question easier I am posting it as a recipe tracker One table has the recipe <tbody> Recipe # Recipe Bread PB Jelly Broth Chicken Noodles 100 PBJ 50% 25% 25% 101 Chicken Soup 75% 10% 15% 102 Chicken Sandwich 50% 50% 103 Peanut Butter Soup 10% 90% </tbody>...
  5. B

    How do you import a module without adding a "1" at the module name?

    Hello, I have an addin that creates mulitple reports and since each of the report modules are updated by a different person, I have code that will delete the old module and import the new one for each one of the reports. The process goes as follows: Delete each of the old modules. Import...
  6. S

    UserForm: "Component not correctly registered"

    When I try to open an Excel-file from my employer with Excel UserForms I recieve following error messages Component not correctly registeredand Unexpected error (336)I can see the code behind the UserForm, but not the UserForm. I've made the same mistake myself last time I created an UserForm...

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