Sorting the values from table 1 to table 2, based on a required/ target percentage.

Hello,

I'm sorry for asking the solution again as the last one did not work as required, but I thank Shams for helping me understand the way it is done. :)

But the problem stays as it is.

So I've put the query as it is in my office excel.

I want to have a list beside which shows the people with percentage below the required/ target percentage, tried many things but noting seems to work properly.

I've attached a sample workbook which explains exactly what is needed and which cells should show the final output.


Thanks in advance.. I'm really stuck with this since ages.
query-workbook.xlsx
arunav ghoshInformation processing specialistAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ShumsDistinguished Expert - 2017Commented:
Hi Arunav,

Please find attached...I have used the same formula which I provided in your earlier post. Please confirm before posting such comments.
query-workbook_v1.xlsx
0
ShumsDistinguished Expert - 2017Commented:
Another way to highlight rows which are below 82% which gives you an idea if my formula is working or not.
query-workbook_v2.xlsx
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
arunav ghoshInformation processing specialistAuthor Commented:
Wonderful person with mind blowing solutions,  way beyond expectation :)
0
ShumsDistinguished Expert - 2017Commented:
You're Welcome Arunav! Glad I was able to help you again.

Thanks for such pleasant comment :)
1
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.