self updating

  1. W

    Please help me out with a Excel formula

    I'm developing a testing platform. I'm struggling to come up with a formula in Excel for the following tasks Add Pass/Fail/Advisory dropdown list. When Fail/Advisory selected from the dropdown list. The user will have to write a few lines about the outcome results. Then all the results then...
  2. A

    automatic correlation matrix by rows

    Hi all, I am a total novice to VBA and I need to build a macro that takes data ordered by row (each rows has about 15 data cells) and calculate a correlation matrix. Thus comparing each row with each other. I know that Tools/data analalysis/correlation is the command I need but I need an...

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