Table range linked to values in another table column?

[MrRodger]

Hi All,

Is it possible to create a master table and then build another table off of the master table by defining a dynamic range of cells that fit a specific criteria like the Tutor column below? I have an example of my master table that contains school, tutor and date. To the right I want a table that can link to the master table and pull in only the values for a particular tutor. I thought this may be possible by defining the subset table ranges with an Index(Match:Index(Match) or some sort of formula in the range field of the table.

Essentially I want a way to break out a new dynamic table for each value in the tutor column using table ranges rather than just formulas in all the cells (like Index(Small(if(row(row) to limit the amount of calculation it takes and to be able to easily refresh data without worrying about someone breaking a formula within a cell or extending the formulas down rows.

[TABLE="width: 715"]
<colgroup><col span="2"><col><col span="8"></colgroup><tbody>[TR]
[TD="colspan: 3"]Master Table[/TD]
[TD][/TD]
[TD="colspan: 3"]Second Table[/TD]
[TD][/TD]
[TD="colspan: 3"]Third Table[/TD]
[/TR]
[TR]
[TD]School[/TD]
[TD]Tutor[/TD]
[TD]Date[/TD]
[TD][/TD]
[TD]School[/TD]
[TD]Tutor[/TD]
[TD]Date[/TD]
[TD][/TD]
[TD]School[/TD]
[TD]Tutor[/TD]
[TD]Date[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]Bill[/TD]
[TD="align: right"]1/2/2015[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD]Bill[/TD]
[TD="align: right"]1/2/2015[/TD]
[TD][/TD]
[TD="align: right"]2[/TD]
[TD]Sara[/TD]
[TD="align: right"]1/3/2015[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]Bill[/TD]
[TD="align: right"]1/2/2015[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD]Bill[/TD]
[TD="align: right"]1/2/2015[/TD]
[TD][/TD]
[TD="align: right"]2[/TD]
[TD]Sara[/TD]
[TD="align: right"]1/3/2015[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]BIll[/TD]
[TD="align: right"]1/3/2015[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD]BIll[/TD]
[TD="align: right"]1/3/2015[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]Bob[/TD]
[TD="align: right"]1/2/2015[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]Bob[/TD]
[TD="align: right"]12/12/2014[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD]Sara[/TD]
[TD="align: right"]1/3/2015[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD]Sara[/TD]
[TD="align: right"]1/3/2015[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 459"]
<colgroup><col span="2"><col><col span="4"></colgroup><tbody></tbody>[/TABLE]

 

[gsistek]

Try using Pivot tables

 

[MrRodger]

Pivot tables would work but they can only summarize fields with counts,sums etc... not display raw data in table format as far as I know. I do not want to use macros and extra processes to get pivot tables to show raw data as my tables will have over a hundred fields assuming I can get this to work as envisioned.