formulas formula

  1. O

    Modelling a Cumulative distribution function for a skewed normal distribution

    Hi, I am trying to create a formula in excel which shows the provides the Cumulative distribution function for a skewed normal distribution giving set parameters for skewness, mean and std. dev. I have done this for a normal distribution using the Norm.Dist (Culminative True) function, but i...
  2. NordicWalker

    Removing Duplicates Based on Date

    I'm new at this, so if I don't explain my problem correctly, please don't shout :cool: Column A = date Column B = name (sometimes multiple occurrences / date) >5000 rows I want it to show ONE occurrence of each name per date. 1) Does that make sense? 2) Can it be done? Cheers ~Phil
  3. L

    Función o Macro para buscar en función de un dato y que me traiga un valor de una columna con vacios

    Tengo una base de datos en la que ingresan valores dos perfiles de usuarios, los unos ingresan determinada información y se registra la fecha en que lo hacen. Estos datos son asignados por el primer perfil de usuario y asignados al segundo perfil, el cual (2do perfil) registra la fecha en...
  4. D

    Making the formula ranking lowest value first instead of highest value first.

    Hi I have a sheet with a formula that ranks a value in order having the highest value ranked as 1 then the next 2 and so on. I cant figure out how to have the lowest value ranked as 1 then the second lowest 2 and so on. My excel sheet lists all the horses for todays racing so I want to rank...

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