optimal

  1. S

    Formula to match and rank with an if statement

    Not sure what I'm trying to do will work. I have been able to return values using LARGE function and gets the rest of the values associated with the number from the data sheet. I now want to add a condition to the formula to only return values that match another criteria...
  2. B

    RAM needed to run Excel

    I'm thinking about buying a laptop. I'm presently looking at a model that has 6GB of RAM, is this enough to run PowerQuerty, PowerPivot, etc? What would be the optimal system configurations for running Excel efficiently? Thank you for your help, Michael
  3. WaqasTariq

    Using Macro: Find optimal bin size for data pasted by user to create a histogram

    I am trying to find a way to create optimal bin size for the data (random size/rows - based on user input) provided by user to create a histogram. The data has random times within a 24 hour time period along with varying quantities. I did find two methods online, but they had issues; The...
  4. A

    what sort of computer to get

    folks, I do a lot of data crunching and make some big spreadsheets for a large company. with the amount of policy stuff running in the background plus my (most probably) personal code/formula style, I seem to always get issues with time. I either get to take a lunch break while files save or I...

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