| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| country list | Excel Discussion (Misc queries) | |||
| List for country names | Excel Discussion (Misc queries) | |||
| Drop down box with country list | New Users to Excel | |||
| Drop down box with country list | New Users to Excel | |||
| Drop down box with country list | New Users to Excel | |||
Linear Mode
