Who can solve that?

**excelfoum123** · 08-19-2014, 12:24 PM

Hi,

I want to show in column C that how many Boys (Column A) make a cumulative %age more than 80%. For example, in Column C the values shown should be the answer

Column A: Boys Boys Boys Girls Girls Girls
Column B: 30% 70% 100% 20% 90% 100%
Column C: 3 3 3 2 2 2

Is it possible to do that?

**6StringJazzer** · 08-19-2014, 02:00 PM

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

**Pepe Le Mokko** · 08-19-2014, 02:22 PM

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.

http://www.excelforum.com/excel-form...ml#post3807137

**6StringJazzer** · 08-19-2014, 06:40 PM

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.