Search results

Hui: I'm trying to learn Monte Carlo simulations to see if I can adapt this to some stuff I want to play with. Thank YOU so much for the latest contribution that PhD Chandoo mailed out to us Excel fans and users, re 'Data Tables and Monte Carlo Simulations.' It was awesome and very...

Hui: THANK YOU !! It appears your formula works like a champ. The actual columns for my spreadsheet data were slightly different from your assumptions, but that was my fault as my post was after a long day, and I was trying to convey the basic structure of what I needed and was grappling...

Hui: Hi and thank you. I will try this and get back to you with the results. The actual columns are much as you assumed. This is an excellent suggestion, I think, and where the columns vary, I think I can adapt your formula. This provides the 'bones' I need for my data to be properly...

I am reading everyone's questions and answers and I am just amazed at the things all of you are doing with Excel. I am more impressed with the creative minds of the members here who are so forthcoming with the great answers and solutions. Chandoo, you PHD you....your site is awesome. Your...

First post, looking for help w/Excel 2007. I have a data set with one column having dates extending to two years. Second column next to data column specifies a status, i.e. "Closed" or "Active" or "Canceled". I have specific starting and ending dates where if a record is listed and it is...