Re: Request for Guidance about sorting the data

[Hazratgi]

Dear Friends,
I hope this message finds you with the best of health and spirit. I am facing a problem with sorting the data. In column 1, I have the names of countries and in column 2 the labels according to countries' names. Column 4 to 8 represents the data sets. But I want to keep the only names of countries+their labels+data, which are unique with column 3. I want to delete all those variable which are not unique with columns 3. Kindly see the attached file and guide me that how can only keep them according to column 2 and column 3 data.

Help for Sorting.png

[JohnTopley]

Answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.

[Hazratgi]

Thanks for the guidance.

[JeteMc]

This proposal employs a helper column (I) which may be moved and/or hidden for aesthetic purposes.
The helper column is populated using: =MATCH(B2,C$2:C$14,0)
The formula that produces the output in K2:Q14 is: =IFERROR(INDEX($A$2:$H$14,AGGREGATE(15,6,(ROW($A$2:$H$14)-ROW($A$1))/($I$2:$I$14>=1),ROWS($A$1:$A1)),MATCH(K$1,$A$1:$H$1,0)),"")
Let us know if you have any questions.

[Hazratgi]

This proposal employs a helper column (I) which may be moved and/or hidden for aesthetic purposes.
The helper column is populated using: =MATCH(B2,C$2:C$14,0)
The formula that produces the output in K2:Q14 is: =IFERROR(INDEX($A$2:$H$14,AGGREGATE(15,6,(ROW($A$2:$H$14)-ROW($A$1))/($I$2:$I$14>=1),ROWS($A$1:$A1)),MATCH(K$1,$A$1:$H$1,0)),"")
Let us know if you have any questions.

Dear JeteMc,
Many thanks for your excellent guidance and support.

[JeteMc]

You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.