Hi
attachment cannot be opened. Post a small sample sheet not a picture - Thx
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!
Attachment 1454
Hi
attachment cannot be opened. Post a small sample sheet not a picture - Thx
Hi
It is too late for your deadline, but I noticed that you say that your criteria is Col F, and you've specified col H as the criteria in your COUNTIF formula. What happens if this is amended to col F ?
Bookmarks