return name from a list by certain country and number of employees

[NicBKK]

Hi Gurus,

I have a list of my factories with country and employees.

I would like to be able to enter a country name and have a list of factories in that country sorted by lowest to highest number of employees.

thanks a lot in advance

[Sam Capricci]

how about trying this... =SORT(FILTER($E$4:$E$28,$C$4:$C$28=H$3),,1)
then drag right.

[HansDouwe]

Please try in H4 and copy to the right:

Please Login or Register  to view this content.