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

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
 
B

Bernard Liengme

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

Am I on the right path 8
how to use an formula to transpose a list(left) to be like the right? 2
How to delete ALL cells containing the same data 0
How to delete ALL cells containing the same data --- REVISED 0
How to delete ALL cells containing the same data 1
Comparing Data 4
excel formula 2
Help with formula 6

Top