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

  • Thread starter Thread starter Michel
  • Start date Start date
M

Michel

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
 
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
 
Back
Top