Link to home
Start Free TrialLog in
Avatar of arunav ghosh
arunav ghoshFlag for India

asked on

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


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.
Avatar of Shums Faruk
Shums Faruk
Flag of India image

Hi Arunav,

Please find attached...I have used the same formula which I provided in your earlier post. Please confirm before posting such comments.
Avatar of Shums Faruk
Shums Faruk
Flag of India image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of arunav ghosh


Wonderful person with mind blowing solutions,  way beyond expectation :)
You're Welcome Arunav! Glad I was able to help you again.

Thanks for such pleasant comment :)