fitting

  1. D

    Excel Query

    Hi, I’m not sure if anyone can help me? I’m trying to write an excel query and have gotten completely stuck. Scenario I’m wanting to write a query that looks at data and gives a response based on the data it queries. It’s actually for fault finding fixed assets for lighting. If we have...
  2. T

    [Excel] Need help in generating formula for Distribution Fitting(Gumbel)

    Hello, I'm currently updating a distribution fitting template used in simulation based on historical data. I found the formula for Gumbel distribution from this thread, which is Location - Scale * LN(-LN(RAND())), for generating x...
  3. B

    Automatically changing the height of a row depening on the data in a specific cell

    Hi all, Im looking for a row to be formatted in such a way that the height automatically changes depening how much data is in a cell within that row. The cell in question is wrapped and can either have say from nothing to numerous email addresses present. Almost to have the effect of double...
  4. L

    Fitting Text in Cell with Changing Font Size (VBA macro to change font size according to Length of Text)

    As can be seen below I need to change font size depending on length of text. I'm complete newbie about VBA macros. I ask for learning also. How to write codes to set if the length of cell is 0-49 set font size 26 if the length of cell is 50-99 set font size 22 if the length of cell is 100-149...

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