ExcelBanter - Can I have the right formula to list all my agencies under country

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Can I have the right formula to list all my agencies under country (https://www.excelbanter.com/excel-worksheet-functions/258314-can-i-have-right-formula-list-all-my-agencies-under-country.html)

Michel

Can I have the right formula to list all my agencies under country

A B
C
A1 COUNTRY AGENCY RESULT FRANCE
A2 FRANCE MAURITOURS W.S.TOURS
A3 FRANCE MAURITOURS CONCORDE
A4 FRANCE MAURITOURS MAURITOURS
A5 FRANCE W.S.TOURS ETC
A6 FRANCE W.S. TOURS
A7 FRANCE CONCORDE
A8 GERMANY KUONI

Bernard Liengme[_2_]

Can I have the right formula to list all my agencies under country

Experiment with Data | Filter
When you filer on say France, you can copy and paste the agencies to another
worksheet
Come back it you still need help - tell us what version of Excel you have
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Michel" wrote in message
...
A B
C
A1 COUNTRY AGENCY RESULT FRANCE
A2 FRANCE MAURITOURS W.S.TOURS
A3 FRANCE MAURITOURS CONCORDE
A4 FRANCE MAURITOURS MAURITOURS
A5 FRANCE W.S.TOURS ETC
A6 FRANCE W.S. TOURS
A7 FRANCE CONCORDE
A8 GERMANY KUONI

Teethless mama

Can I have the right formula to list all my agencies under country

Try Pivot Table

"Michel" wrote:

A B
C
A1 COUNTRY AGENCY RESULT FRANCE
A2 FRANCE MAURITOURS W.S.TOURS
A3 FRANCE MAURITOURS CONCORDE
A4 FRANCE MAURITOURS MAURITOURS
A5 FRANCE W.S.TOURS ETC
A6 FRANCE W.S. TOURS
A7 FRANCE CONCORDE
A8 GERMANY KUONI

All times are GMT +1. The time now is 10:03 PM.