Display data with filters

M

maf

Hi,

I have an excel document with filters by each column. Each cell of a column
has data separated by semicolumns (example: a;b;c;). What I need to do is to
be able to select one value through the filter in a column and the excel
present all correspondent values in that semicolon in the others columns.

Example:
1st column: A;B;C
2nd column: 1;2;3
3rd column: 2004;2005;2006

If I choose the value A in the filter placed in the 1st column, I need that
in the 2nd and 3rd column it appears: 1 and 2004 respectively.

If I choose the value C in the filter placed in the 1st column, I need that
in the 2nd and 3rd column it appears: 3 and 2006 respectively.

Thanks for your help.
Margarida Freire
 
Top