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

arunav ghosh
arunav ghosh used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
ShumsManaging Director/Excel VBA Developer
Distinguished Expert 2018

Commented:
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
Managing Director/Excel VBA Developer
Distinguished Expert 2018
Commented:
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
arunav ghoshInformation processing specialist

Author

Commented:
Wonderful person with mind blowing solutions,  way beyond expectation :)
ShumsManaging Director/Excel VBA Developer
Distinguished Expert 2018

Commented:
You're Welcome Arunav! Glad I was able to help you again.

Thanks for such pleasant comment :)

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial