steveyeoks
New member
- Joined
- Jul 2, 2013
- Messages
- 1
- Reaction score
- 0
- Points
- 0
Hi guys, i desperately need help on this. I have a report to submit by WED! Any help is appreciated!
Attached is the picture to give a clearer idea.
I'm trying to to do monte carlo simulation. I have one column created (G21 to G1020) and the another column (F) is the specific value that will occur in the range (G21 to G1020). Lastly, i did a Countif function with range (G21 to G1020) and criteria is the specific value from the the column (F). Formula: =COUNTIF($G$21:$G$1020,H21)
Please tell me what did i miss out. Really appreciate your help with this. Thank you!
View attachment 1454
Attached is the picture to give a clearer idea.
I'm trying to to do monte carlo simulation. I have one column created (G21 to G1020) and the another column (F) is the specific value that will occur in the range (G21 to G1020). Lastly, i did a Countif function with range (G21 to G1020) and criteria is the specific value from the the column (F). Formula: =COUNTIF($G$21:$G$1020,H21)
Please tell me what did i miss out. Really appreciate your help with this. Thank you!
View attachment 1454