Prev: How do I filter data by more than one column in excel
Next: Multi tab Workbooks
From: Michel on 8 Mar 2010 12:11
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
From: Bernard Liengme on 8 Mar 2010 12:56
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" <Michel(a)discussions.microsoft.com> wrote in message
news:2FAB1003-7D50-4622-AC51-26454A2D6A73(a)microsoft.com...
> 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

From: Teethless mama on 8 Mar 2010 13:13
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
 | 
Pages: 1
Prev: How do I filter data by more than one column in excel
Next: Multi tab Workbooks