SORTING without headers on excel

[Guy-Ghislain APPIAH]

Hi my Name is Guy-Ghislain, I'am a french man, I am very happy to be on this website with all of us to solve problem on excel.
My problem is that I would like to sort data in ascending order as descending in an excel table from a cell other than the headers of tables that contain differents KPIs as in the attached excel sheet post with a dropdown of the KPI choose to automate the sorting.

 

[Khalid NGO]

Hi,

Can you please post your expected result ?

Regards,

 

[bosco_yip]

Maybe…….

1] In F5, copy down :

=IF(G5<>"",INDEX(A$2:A$13,MATCH(G5,INDEX(B$2:D$13,0,MATCH(G$4,B$1:D$1,0)),0)),"")

2] In G5, copy down :

=IFERROR(SMALL(INDEX(B$2:D$13,0,MATCH(G$4,B$1:D$1,0)),ROWS($1:1)),"")

3] Dropdown of the KPI in cell G4

Regards
Bosco