I am looking to ensure that the contents of column AF, which can have mulitple values, pulled from a sharepoint site, only has the value associated with the value in column H. I like this to work through all of the rows in the spreadsheet.
H contains: Apple
AF contains: Apple=2, Orange=3
I would like to end up with AF containing: Apple=2
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…