Avatar of arunav ghosh
arunav ghosh
Flag for India asked on

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
Microsoft OfficeSpreadsheetsMicrosoft Excel

Avatar of undefined
Last Comment
Shums Faruk

8/22/2022 - Mon
Shums Faruk

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
ASKER CERTIFIED SOLUTION
Shums Faruk

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
arunav ghosh

ASKER
Wonderful person with mind blowing solutions,  way beyond expectation :)
Shums Faruk

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

Thanks for such pleasant comment :)
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck