How to Calculate the unites the sold over 70%!

[Unseen]

hello guys

so Basically i want all the names, units of the games that sold over 70% , you can see the empty schedule below the one in the top, that's what i want! thanks and sry if i didn't explain it good.

what do i use? do i use if or match?

http://www.mediafire.com/?9hmyendjtiuwydp

[dilipandey]

HI Unseen,

welcome to the forum.

Suggest you to change thread title to reflect the query you are asking.. see the forum rules:-

http://www.excelforum.com/forum-rule...rum-rules.html

Regards,
DILIPandey

<click on below 'star' if this helps>

[kbkumar]

Welcome to the forum.

Its not clear what you are aiming to achieve. Are you able to upload a workbook and explain?

[Blake 7]

http://www.excelforum.com/forum-rule...rum-rules.html

Please aquaint yourself with the forum rules above.

Not only does your thread title not adhear to the rules - it also comes across as rude, unless omitting the please and replacing it with a ! is acceptable to you.

[Unseen]

thanks dilipandey, i hope it's much clearer now...

Kbkumar, you c the games in the stock before the sell " before sell " and games AFTER the sell? I want to compare the two columns so i can get all the games that sell 70% or more... i already solved the (Available) one.

HOPE IT'S CLEAR NOW . AND SRY FOR MY BAD ENGLISH GUYS!!!

[Unseen]

I don't know how to chose a better title to describe my problem,,,