Well I have a list with names and countries:
Country Name
US Ben
UK John
UK Liza
FR Karen
US Carl
FR Sophie
US Anders
Now I sort this list according to coutry. In another sheet I want to extra the data in this list, but only the data that is sorted. So let's say I sort the list on US I only want the names that is filtered/US to show in the other list?
Can this be done. Have problems with this, help would be highly appreciated.
/Per
Country Name
US Ben
UK John
UK Liza
FR Karen
US Carl
FR Sophie
US Anders
Now I sort this list according to coutry. In another sheet I want to extra the data in this list, but only the data that is sorted. So let's say I sort the list on US I only want the names that is filtered/US to show in the other list?
Can this be done. Have problems with this, help would be highly appreciated.
/Per