Summary that matches cell and includes row information

[a5972s]

Hi there,

If I have a static table that I want to create a summary from.

For e.g.

A B C
1 Andy M 23
2 Mary F 46
3 Mike M 17
4 Beck F 35
5 Tom M 29

Column A is static, so I want to create a summary table below it with only entries in column B that match 'M' which also includes column A, B & C data too?

So my table summary should look something like this

A B C
10 Andy M 23
11 Mike M 17
12 Tom M 29

Any ideas?

 

[sandy666]

try PivotTable

[Table="width:, class:head"]
[tr=bgcolor:#FFFFFF][td]Name[/td][td]Type[/td][td]Value[/td][td][/td][td][/td][td=bgcolor:#DDEBF7]Type[/td][td=bgcolor:#DDEBF7]M[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Andy[/td][td]M[/td][td]

23​

[/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td]Mary[/td][td]F[/td][td]

46​

[/td][td][/td][td][/td][td=bgcolor:#DDEBF7]Name[/td][td=bgcolor:#DDEBF7]Sum of Value[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Mike[/td][td]M[/td][td]

17​

[/td][td][/td][td][/td][td]Andy[/td][td]

23​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Beck[/td][td]F[/td][td]

35​

[/td][td][/td][td][/td][td]Mike[/td][td]

17​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Tom[/td][td]M[/td][td]

29​

[/td][td][/td][td][/td][td]Tom[/td][td]

29​

[/td][/tr]
[/table]

 

[a5972s]

Do PivotTables work with text only tables?

 

[sandy666]

PivotTable works with with text and numbers