I need help with excel macro.
Please see attached file.
What I need is:
1. look in spreadsheet and if A2 & B2 = G (any) & H (any) take correct (I) and put in E2, loop,
check another record etc.
I have around 200 records both sections.
put 1 into E2
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.