Spreadsheet: 490675d1479996854-filter-a-given-value-on-multiple-excal-tables-at-once-excel-forum-example
Sheet: Options

 |  |  |  |  |  |  |  | How many units?
Document | Spalte1 | Spalte2 | Spalte3 | Spalte4 | Spalte5 | Spalte6 | Spalte7 | Unit 1 | Unit 2 | Unit 3 | Unit 4 | Unit 5 | Unit 6 | Unit 7 | Unit 8 | Unit 9 | Unit 10 | Unit 11 | Unit 12 | Unit 13 | Unit 14 | Unit 15 | Unit 16 | Unit 17
Document 1 |  |  |  |  |  |  |  | x |  |  | x | x |  | x | x | x | x | x | x | x |  | x | x
Document 2 |  |  |  |  |  |  |  | x | x | x | x |  | x |  |  |  |  |  |  |  | x | x | x
Document 3 |  |  |  |  |  |  |  | x | x | x | x |  | x |  |  |  |  |  |  |  | x | x | x | x
Document 4 |  |  |  |  |  |  |  | x |  |  | x | x |  | x |  | x | x | x | x | x |  | x | x
Document 5 |  |  |  |  |  |  |  | x |  | x | x | x | x |  |  |  |  |  |  | x | x | x | x
Document 6 |  |  |  |  |  |  |  | x |  | x | x | x | x |  |  |  |  |  |  | x | x | x | x
Document 7 |  |  |  |  |  |  |  | x |  | x | x | x | x |  |  |  |  |  |  |  | x | x | x
Document 8 |  |  |  |  |  |  |  | x | x | x | x |  | x |  |  |  |  |  |  |  | x | x | x | x
Document 9 |  |  |  |  |  |  |  | x | x | x | x |  | x |  |  |  |  |  |  |  | x | x | x | x
Document 10 |  |  |  |  |  |  |  | x |  | x | x |  | x |  |  |  |  |  |  |  | x | x | x | x
Document 11 |  |  |  |  |  |  |  | x |  | x | x |  | x |  |  |  |  |  |  |  | x | x | x
 |  |  |  |  |  |  |  | How many items per unit?
Document | Spalte1 | Spalte2 | Spalte3 | Spalte4 | Spalte5 | Spalte6 | Spalte7 | Unit 1 | Unit 2 | Unit 3 | Unit 4 | Unit 5 | Unit 6 | Unit 7 | Unit 8 | Unit 9 | Unit 10 | Unit 11 | Unit 12 | Unit 13 | Unit 14 | Unit 15 | Unit 16 | Unit 17
Document 1 |  |  |  |  |  |  |  | 6 |  |  | 4 |  |  | 2 | 2 | 2 | 2 | 2 | 2 | 2 |  | 3+1+1 | 2
Document 2 |  |  |  |  |  |  |  | 4 | 3 | 3 | 2 |  | 0 |  |  |  |  |  |  |  | 2 | 3+1 | 1
Document 3 |  |  |  |  |  |  |  | 4 | 4 | 4 | 4 |  | 4 |  |  |  |  |  |  |  |  | 4+1 | 1 | 1
Document 4 |  |  |  |  |  |  |  | 6 |  |  | 5 |  |  | 2 |  | 2 | 2 | 2 | 2 | 2 |  | 3+1+1 | 2
Document 5 |  |  |  |  |  |  |  | 6 |  | 4 | 5 | 1 | 6 |  |  |  |  |  |  | 5 | 3 | 4+1 | 1
Document 6 |  |  |  |  |  |  |  | 5 | 4 | 4 | 4 |  | 1 |  |  |  |  |  |  |  | 3 | 4+1 | 1 | 1
Document 7 |  |  |  |  |  |  |  | 4 | 4 | 4 | 4 |  | 4 |  |  |  |  |  |  |  | 3 | 4+1 | 1 | 1
Document 8 |  |  |  |  |  |  |  | 5 |  | 4 | 4 |  | 4 |  |  |  |  |  |  |  | 3 | 4+1 | 1 | 1
Document 9 |  |  |  |  |  |  |  | 6 |  | 4 | 5 | 1 | 6 |  |  |  |  |  |  | 5 | 3 | 4+1 | 1
Document 10 |  |  |  |  |  |  |  | 6 |  | 4 | 5 | 1 | 6 |  |  |  |  |  |  | 5 | 3 | 4+1 | 1
Document 11 |  |  |  |  |  |  |  | 6 |  | 4 | 3 |  | 0 |  |  |  |  |  |  |  | 3 | 2+1+1 | 3
 |  |  |  |  |  |  |  | "Item 2" : in which unit?
Document | Spalte1 | Spalte2 | Spalte3 | Spalte4 | Spalte5 | Spalte6 | Spalte7 | Unit 1 | Unit 2 | Unit 3 | Unit 4 | Unit 5 | Unit 6 | Unit 7 | Unit 8 | Unit 9 | Unit 10 | Unit 11 | Unit 12 | Unit 13 | Unit 14 | Unit 15 | Unit 16 | Unit 17
Document 1 |  |  |  |  |  |  |  |  |  |  | x
Document 2 |  |  |  |  |  |  |  |  |  | x
Document 3 |  |  |  |  |  |  |  |  |  | x
Document 4 |  |  |  |  |  |  |  |  |  |  |  | x
Document 5 |  |  |  |  |  |  |  |  |  |  |  | x
Document 6 |  |  |  |  |  |  |  |  |  | x
Document 7 |  |  |  |  |  |  |  |  |  | x
Document 8 |  |  |  |  |  |  |  |  |  | x
Document 9 |  |  |  |  |  |  |  |  |  |  |  | x
Document 10 |  |  |  |  |  |  |  |  |  |  |  | x
Document 11 |  |  |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | "Item 3" : in which unit?
Document | Spalte1 | Spalte2 | Spalte3 | Spalte4 | Spalte5 | Spalte6 | Spalte7 | Unit 1 | Unit 2 | Unit 3 | Unit 4 | Unit 5 | Unit 6 | Unit 7 | Unit 8 | Unit 9 | Unit 10 | Unit 11 | Unit 12 | Unit 13 | Unit 14 | Unit 15 | Unit 16 | Unit 17
Document 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
Document 2 |  |  |  |  |  |  |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
Document 3 |  |  |  |  |  |  |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
Document 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
Document 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
Document 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
Document 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
Document 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
Document 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
Document 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
Document 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | "Item 4" : in which unit?
Document | Spalte1 | Spalte2 | Spalte3 | Spalte4 | Spalte5 | Spalte6 | Spalte7 | Unit 1 | Unit 2 | Unit 3 | Unit 4 | Unit 5 | Unit 6 | Unit 7 | Unit 8 | Unit 9 | Unit 10 | Unit 11 | Unit 12 | Unit 13 | Unit 14 | Unit 15 | Unit 16 | Unit 17
Document 1 |  |  |  |  |  |  |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
Document 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
Document 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
Document 4 |  |  |  |  |  |  |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
Document 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
Document 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
Document 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
Document 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
Document 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
Document 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
Document 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | "Item 5" : in which unit?
Document | Spalte1 | Spalte2 | Spalte3 | Spalte4 | Spalte5 | Spalte6 | Spalte7 | Unit 1 | Unit 2 | Unit 3 | Unit 4 | Unit 5 | Unit 6 | Unit 7 | Unit 8 | Unit 9 | Unit 10 | Unit 11 | Unit 12 | Unit 13 | Unit 14 | Unit 15 | Unit 16 | Unit 17
Document 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
Document 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
Document 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
Document 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
Document 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
Document 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
Document 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
Document 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
Document 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
Document 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
Document 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x