Sort data in several columns without using pivot table

Hi. Am trying to sort values in several columns but based on values in one of the columns (COLUMN D) in descending order using a formula. Attached is a workbook named SAMPLE 5 with raw data in a worksheet named TEST. Expected results are in a different worksheet named RESULTS.
I would be grateful for your assistance. Thanks
Attached is my workbook, named SAMPLE 5

Originally Posted by KIBAAKO

Am trying to sort values in several columns but based on values in one of the columns (COLUMN D) in descending order using a formula.

Is that correct, or should it be column E?

Am very sorry, you are right, it should Column E. Thanks

Not a problem, an easy mistake to make.

Try entering this formula into E4

Formula:

Please Login or Register  to view this content.

this one into A4, then fill right to D4

Formula:

Please Login or Register  to view this content.

and this one into F4, then fill right to AB4

Formula:

Please Login or Register  to view this content.

finally, fill all of them down about 100 rows.

Thanks, it worked excellently, be blessed abundantly.