utilities

  1. L

    ASAP utilities

    Hi All, Have tried to install newest version of asap utilities. Does not display on tool bar. When I go Tools>>Addins>>Browse and select the asap utility it says it is not a true addin?:confused: Any suggestions? Forgot to mention I use Excel 2003 but I have Excel 2013 on computer. The ASAP...
  2. M

    Managing large personal.xlsb file

    I've got 20 years of utilities, forms, classes, and other macros in my personal.xlsb file. It's over 1MB now and while I use some macros more than others I don't want to leave any out for when I need them. I know it's a big chunk of memory to load the file, even if particular modules aren't...
  3. R

    Help with this excel problem

    Good afternoon everyone, I have been given this exercise to complete and the instructions seem very vague so not sure how to solve the issue they are asking. Also the way they are doing some of the calculations are straightforward but really weird and do not make sense to me. Looking at the...
  4. C

    Iferror / index

    Good morning Forum :cool:, Here is my formula: In 'Sheet 1' (cell J3) =IFERROR(INDEX('Raw Data'!$B$3:$B$900,SMALL(IF(1=((--($D$6='Raw Data'!$A$3:$A$900))*(--($E$6='Raw Data'!$D$3:$D$900))),ROW('Raw Data'!$B$3:$B$900)-0,""),COLUMN()-1)),"") my two criteria's are - "Position Title" &...

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