excel 2010 formulas

  1. C

    Median Calculation on multiple criteria

    So i've been struggling with this. Is there a way to calculate the median of a set of values based on Name and volume? An example of the data layout is below, what i want is to calculate the median value for a large table with multiple entries using formula or VBA. <tbody> Name Volume Value...
  2. S

    Comparison and identifying & listing unique values in the Columns

    Hello all, I am working on an automation task, where i am requried to compare & identify the unique part numbers from Base-BOM & other BOMS. my needs are as follows: 1) The mismatching values should get highlighted and the values of those cells should be copied to another cells I have worked on...
  3. K

    Extracting last row data in col A from another worksheet based on list

    Hello, I'm hoping someone can assist. I have run into another issue. I have a workbook that has several sheets. The sheets are created based on a named range. What I am trying to do is with the main worksheet ("Project Tracker"), I am trying to enter a formula in the Due by date. If the...
    • KayWill
    • Thread
    • excel 2010 formulas excel formuals index count array indirect reference
    • Replies: 4
    • Forum: Excel Questions
  4. D

    Check values in 4 cells and return appropriate remarks depending on the cell value

    Greetings, Please help me creating a formula for the following requirement. I have prepared an excel sheet with over 150 parameter taking input from phd uniformance (historian) and compared them with their respective set alarm &trip values. I have shown four such parameters (Steam Turbine...

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