1. B

    VBA or Formula to populate range of cells with set frequency of pre-defined values.

    Hello, Please see below table: ABCDEFG1ValuesValueOccurrenceNew count of values:652BBBAAA10%3AAAAAB5%Values:4AABABA15%5ABAABB15%6AAABAA15%7ABBBAB15%8BABBBA15%9BBABBB10%10BBB11ABA12BAB13BAA14BBA15ABB16BAA17BBA18ABA19ABB20BAB21BAAD2:D9D2=COUNTIF($A$2:$A$21,C2)/20 Column C contains a list of...
  2. F

    Move Rows based on cell value

    Help! I am trying to create a VBA Code that is pulls from a list that equals one of the following: "Transport" "Level 1/2" "Level 3" "One to One" or "Youth Work". The information starts on the 2nd row and 8th Column. I need all of the information in the row to sort into their own worksheets...
  3. T

    How do I redistribute sales fairly if I want to increase the growth percentage?

    I am working on a sales forecast for 2020. The forecast has 92 locations and I have sales by week by site for Period 1 2019 and a forecast of sales by week for Period 1 2020. Period 1 2019 Sales Total: $11,586,579 Period 1 2020 Sales Forecast: $11,57,090 Dollar Change in sales 2019 to 2020...
  4. T

    Evenly assign workload to available employees following priority

    Hello! I have a spreadsheet with a list of items each day pertaining to cases employees work. Each case has an assigned owner but cases pile up and need to be evenly distributed. I’ve attached a dumbed down version of my spreadsheet without sensitive information. I need to assign the list...
  5. S

    Macro to pull members from distribution list.

    Hi All, New to the Excel world. Need your help in providing me the excel macro to pull the member details from outlook distribution list. Can any one help me. Thank You !! Regards, Santy
  6. M

    Which histogram formula is correct?

    Poking around on the web I find various formulas for creating histograms. I'm getting different results for each formula and I want to know which one is accurate. I have a table of purchase orders and I want to get the distribution of how many POs are in various dollar ranges (e.g. how many...
  7. A

    Email distribution list

    Is there any way to be able to access a spreadsheet based distribution list from outlook without having to create and then edit (as changes are made in the original spreadsheet) a static contact list in outlook?
  8. 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...
  9. U

    Degree Of Freedom For Student T Distribution

    I need help on how to estimate the degree of freedom using Maximum Likelihood procedure for student t distribution. I am working with multivariate random variables.
  10. F

    Frequency Distribution of streaks

    Hello, I need the frequency distribution of streaks like 0 -1 -1 -> 2 0 0 -1 -1 -1 -> 3 0 Is there a way to create a column like column 2 in excel so that I can create a histogram that shows the data. Thanks for any help.
  11. H

    Forecasting Curve Distribution

    Hello, I am working on a forecasting model and have run into some trouble when trying to extend the X-Axis of a 12-month Curve Distribution to a longer time frame. Given a distribution of 12 percentages (one for each month), how can I spread the 12 months or periods to say 18 months while...
  12. D

    Cell Distribution

    Hello, Just want to ask if there is an easy way to distribute the data from Column A to Column B, the result will be on Column D&E.
  13. E

    Exponential distribution

    Hi there, How do i generate a set of data using exponential distribution with a mean of 10? Thank you!
  14. J

    Formula/UDF for Variance for Folded Normal distribution

    I am looking for a formula/UDF for computing the Variance of Folded-Normal distribution. The formula for the same can be referenced at https://en.wikipedia.org/wiki/Folded_normal_distribution
  15. S

    Excel - Outlook Connection

    Hi I put together an Excel report each morning that takes up one worksheet (about 55 rows & 26 columns). Once compiled, I have to email it out to a distribution list. Is there some way (may code based) that I can have a button on that worksheet that I activate that then automatically places...
  16. M

    Multiple based prorate distribution by weights

    I'd need to proportionally distribute (prorate) a value (integer number of products for a promotion) - by multiple of n - across a list, based on the relative weights (i.e. distribution of the sales) of "basis" values in the list.
  17. M

    Why my data does not give a bell curve graph? normal distribution formulas used

    Hi Guys, I have been trying to create a bell curve / normal distribution chart but my data does not give a belle curve. What do I do wrong ? Given X values, I use formula z= STANDARDIZE Fx = NORM.DIST <colgroup><col span="3"></colgroup><tbody> X z f(x) 490 0.9 0.029 490 0.9 0.029...
  18. N

    modeling Monte Carlo with non-standard distribution

    Hello everybody, I'm using the NORMINV() function to calculate likely random outcomes of specific variables in a Monte Carlo simulation. (Modeling this after the example from the excellent book, How To Measure Anything.) However, NORMINV() uses standard distribution. What if my distribution is...
  19. M

    Extracting from a column

    IV:9710388235LADD DISTRIBUTION LLC Did a search on extract, but couldnt find a solution, so I wanted to see if someone could help out. I want to populate 3 columns from 1 column. Column 1 would have IV: - simple enough as I can trim 3 characters. Column 2 would have 9710388235 - Anything...
  20. L

    Powerpivot distribution by Zone/Area - security options

    Hi, I am new to powerpivots. I have an Excel report with Data Model that I am looking to distribute to different Zone owners. There are 7 Zones, and the source data has all of them. How do I limit the report that I distribute only to one Zone since I do not want other Zone owners to see other...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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