A bit of an explanation regarding my workbook. I have two worksheets. The Data sheet containing the table 'Table_Data' which contains ledger transaction amounts and LedgerSummary which contains the table 'Table_Summary' detailing account transaction totals.
I use SUMIFS to determine values for...
I was wondering if anyone has any vba for a negative exponential distribution. In particular, I'd like to generate a number with a mean as a parameter. I'm using vba to build a schedule based on statistical data.