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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to use an formula to transpose a list(left) to be like the right? 2
Am I on the right path 8
Comparing Data 4
Finding last cell with a value and then adding to another 2
Vlookup for part Lookup_value 4
Help with formula 6
excel formula 2
Find the number of the lowest filled row 3

Back
Top