Spreadsheet: 866964d1713874765-tocol-function-to-show-non-zero-values-only-filter
Sheet: Sheet1

 |  | ENTITY
 | ACCOUNT | ABC1 | [NAME] | ABC3 | [NAME] | ABC5 | ABC6 | ABC7 |  | TOCOL |  | FILTER in 1 column |  | FILTER in more columns
 | 123 | 17 | 16 | 10 | 13 |  | 15 | 11
 | 124 |  | 11 |  | 11 | 17 | 18 | 20 |  | 123|ABC2|16 |  | 14 |  |  | 123|ABC2|16
 | 125 | 14 | 16 | 11 | 11 |  | 12 | 16 |  | 123|ABC3|10 |  | 17 |  |  | 123|ABC3|10
 | 126 | 17 |  |  | 15 | 12 | 13 |  |  | 123|ABC4|13 |  | 12 |  |  | 123|ABC4|13
 | 127 |  | 10 | 13 |  |  |  |  |  | 123|ABC5 |  | 13 |  |  | 123|ABC6|15
 | 128 |  | 16 |  |  | 11 | 17 |  |  | 123|ABC6|15 |  | 14 |  |  | 123|ABC7|11
 | 129 | 12 | 18 | 12 | 14 |  | 15 | 10 |  | 123|ABC7|11 |  | 15 |  |  | 124|ABC2|11
 | 130 |  |  | 13 | 20 | 14 | 15 |  |  | 124|ABC1 |  | 19 |  |  | 124|ABC4|11
 | 131 | 13 |  |  |  |  | 15 | 16 |  | 124|ABC2|11 |  | 20 |  |  | 124|ABC5|17
 | 132 | 14 | 14 | 20 | 11 |  |  |  |  | 124|ABC3 |  | 10 |  |  | 124|ABC6|18
 | 133 |  | 16 | 19 | 19 | 20 | 15 | 10 |  | 124|ABC4|11 |  |  |  |  | 124|ABC7|20
 | 134 | 15 | 14 |  |  | 11 | 16 | 16 |  | 124|ABC5|17 |  |  |  |  | 125|ABC1|14
 | 135 | 19 | 13 | 14 |  | 12 |  | 11 |  | 124|ABC6|18 |  |  |  |  | 125|ABC2|16
 | 136 | 20 |  | 12 |  | 10 | 20 |  |  | 124|ABC7|20 |  |  |  |  | 125|ABC3|11
 | 137 |  | 12 | 10 |  |  | 12 | 12 |  | 125|ABC1|14 |  |  |  |  | 125|ABC4|11
 | 138 | 10 |  |  | 18 | 15 | 13 | 16 |  | 125|ABC2|16 |  |  |  |  | 125|ABC6|12
 | 139 |  | 13 | 14 | 12 | 14 | 13 | 18 |  | 125|ABC3|11 |  |  |  |  | 125|ABC7|16
 |  |  |  |  |  |  |  |  |  | 125|ABC4|11 |  |  |  |  | 126|ABC1|17
 |  |  |  |  |  |  |  |  |  | 125|ABC5 |  |  |  |  | 126|ABC4|15
 |  |  |  |  |  |  |  |  |  | 125|ABC6|12 |  |  |  |  | 126|ABC5|12
 |  |  |  |  |  |  |  |  |  | 125|ABC7|16 |  |  |  |  | 126|ABC6|13
 |  |  |  |  |  |  |  |  |  | 126|ABC1|17 |  |  |  |  | 127|ABC2|10
 |  |  |  |  |  |  |  |  |  | 126|ABC2 |  |  |  |  | 127|ABC3|13
 |  |  |  |  |  |  |  |  |  | 126|ABC3 |  |  |  |  | 128|ABC2|16
 |  |  |  |  |  |  |  |  |  | 126|ABC4|15 |  |  |  |  | 128|ABC5|11
 |  |  |  |  |  |  |  |  |  | 126|ABC5|12 |  |  |  |  | 128|ABC6|17
 |  |  |  |  |  |  |  |  |  | 126|ABC6|13 |  |  |  |  | 129|ABC1|12
 |  |  |  |  |  |  |  |  |  | 126|ABC7 |  |  |  |  | 129|ABC2|18
 |  |  |  |  |  |  |  |  |  | 127|ABC1 |  |  |  |  | 129|ABC3|12
 |  |  |  |  |  |  |  |  |  | 127|ABC2|10 |  |  |  |  | 129|ABC4|14
 |  |  |  |  |  |  |  |  |  | 127|ABC3|13 |  |  |  |  | 129|ABC6|15
 |  |  |  |  |  |  |  |  |  | 127|ABC4 |  |  |  |  | 129|ABC7|10
 |  |  |  |  |  |  |  |  |  | 127|ABC5 |  |  |  |  | 130|ABC3|13
 |  |  |  |  |  |  |  |  |  | 127|ABC6 |  |  |  |  | 130|ABC4|20
 |  |  |  |  |  |  |  |  |  | 127|ABC7 |  |  |  |  | 130|ABC5|14
 |  |  |  |  |  |  |  |  |  | 128|ABC1 |  |  |  |  | 130|ABC6|15
 |  |  |  |  |  |  |  |  |  | 128|ABC2|16 |  |  |  |  | 131|ABC1|13
 |  |  |  |  |  |  |  |  |  | 128|ABC3 |  |  |  |  | 131|ABC6|15
 |  |  |  |  |  |  |  |  |  | 128|ABC4 |  |  |  |  | 131|ABC7|16
 |  |  |  |  |  |  |  |  |  | 128|ABC5|11 |  |  |  |  | 132|ABC1|14
 |  |  |  |  |  |  |  |  |  | 128|ABC6|17 |  |  |  |  | 132|ABC2|14
 |  |  |  |  |  |  |  |  |  | 128|ABC7 |  |  |  |  | 132|ABC3|20
 |  |  |  |  |  |  |  |  |  | 129|ABC1|12 |  |  |  |  | 132|ABC4|11
 |  |  |  |  |  |  |  |  |  | 129|ABC2|18 |  |  |  |  | 133|ABC2|16
 |  |  |  |  |  |  |  |  |  | 129|ABC3|12 |  |  |  |  | 133|ABC3|19
 |  |  |  |  |  |  |  |  |  | 129|ABC4|14 |  |  |  |  | 133|ABC4|19
 |  |  |  |  |  |  |  |  |  | 129|ABC5 |  |  |  |  | 133|ABC5|20
 |  |  |  |  |  |  |  |  |  | 129|ABC6|15 |  |  |  |  | 133|ABC6|15
 |  |  |  |  |  |  |  |  |  | 129|ABC7|10 |  |  |  |  | 133|ABC7|10
 |  |  |  |  |  |  |  |  |  | 130|ABC1 |  |  |  |  | 134|ABC1|15
 |  |  |  |  |  |  |  |  |  | 130|ABC2 |  |  |  |  | 134|ABC2|14
 |  |  |  |  |  |  |  |  |  | 130|ABC3|13 |  |  |  |  | 134|ABC5|11
 |  |  |  |  |  |  |  |  |  | 130|ABC4|20 |  |  |  |  | 134|ABC6|16
 |  |  |  |  |  |  |  |  |  | 130|ABC5|14 |  |  |  |  | 134|ABC7|16
 |  |  |  |  |  |  |  |  |  | 130|ABC6|15 |  |  |  |  | 135|ABC1|19
 |  |  |  |  |  |  |  |  |  | 130|ABC7 |  |  |  |  | 135|ABC2|13
 |  |  |  |  |  |  |  |  |  | 131|ABC1|13 |  |  |  |  | 135|ABC3|14
 |  |  |  |  |  |  |  |  |  | 131|ABC2 |  |  |  |  | 135|ABC5|12
 |  |  |  |  |  |  |  |  |  | 131|ABC3 |  |  |  |  | 135|ABC7|11
 |  |  |  |  |  |  |  |  |  | 131|ABC4 |  |  |  |  | 136|ABC1|20
 |  |  |  |  |  |  |  |  |  | 131|ABC5 |  |  |  |  | 136|ABC3|12
 |  |  |  |  |  |  |  |  |  | 131|ABC6|15 |  |  |  |  | 136|ABC5|10
 |  |  |  |  |  |  |  |  |  | 131|ABC7|16 |  |  |  |  | 136|ABC6|20
 |  |  |  |  |  |  |  |  |  | 132|ABC1|14 |  |  |  |  | 137|ABC2|12
 |  |  |  |  |  |  |  |  |  | 132|ABC2|14 |  |  |  |  | 137|ABC3|10
 |  |  |  |  |  |  |  |  |  | 132|ABC3|20 |  |  |  |  | 137|ABC6|12
 |  |  |  |  |  |  |  |  |  | 132|ABC4|11 |  |  |  |  | 137|ABC7|12
 |  |  |  |  |  |  |  |  |  | 132|ABC5 |  |  |  |  | 138|ABC1|10
 |  |  |  |  |  |  |  |  |  | 132|ABC6 |  |  |  |  | 138|ABC4|18
 |  |  |  |  |  |  |  |  |  | 132|ABC7 |  |  |  |  | 138|ABC5|15
 |  |  |  |  |  |  |  |  |  | 133|ABC1 |  |  |  |  | 138|ABC6|13
 |  |  |  |  |  |  |  |  |  | 133|ABC2|16 |  |  |  |  | 138|ABC7|16
 |  |  |  |  |  |  |  |  |  | 133|ABC3|19 |  |  |  |  | 139|ABC2|13
 |  |  |  |  |  |  |  |  |  | 133|ABC4|19 |  |  |  |  | 139|ABC3|14
 |  |  |  |  |  |  |  |  |  | 133|ABC5|20 |  |  |  |  | 139|ABC4|12
 |  |  |  |  |  |  |  |  |  | 133|ABC6|15 |  |  |  |  | 139|ABC5|14
 |  |  |  |  |  |  |  |  |  | 133|ABC7|10 |  |  |  |  | 139|ABC6|13
 |  |  |  |  |  |  |  |  |  | 134|ABC1|15 |  |  |  |  | 139|ABC7|18
 |  |  |  |  |  |  |  |  |  | 134|ABC2|14
 |  |  |  |  |  |  |  |  |  | 134|ABC3
 |  |  |  |  |  |  |  |  |  | 134|ABC4
 |  |  |  |  |  |  |  |  |  | 134|ABC5|11
 |  |  |  |  |  |  |  |  |  | 134|ABC6|16
 |  |  |  |  |  |  |  |  |  | 134|ABC7|16
 |  |  |  |  |  |  |  |  |  | 135|ABC1|19
 |  |  |  |  |  |  |  |  |  | 135|ABC2|13
 |  |  |  |  |  |  |  |  |  | 135|ABC3|14
 |  |  |  |  |  |  |  |  |  | 135|ABC4
 |  |  |  |  |  |  |  |  |  | 135|ABC5|12
 |  |  |  |  |  |  |  |  |  | 135|ABC6
 |  |  |  |  |  |  |  |  |  | 135|ABC7|11
 |  |  |  |  |  |  |  |  |  | 136|ABC1|20
 |  |  |  |  |  |  |  |  |  | 136|ABC2
 |  |  |  |  |  |  |  |  |  | 136|ABC3|12
 |  |  |  |  |  |  |  |  |  | 136|ABC4
 |  |  |  |  |  |  |  |  |  | 136|ABC5|10
 |  |  |  |  |  |  |  |  |  | 136|ABC6|20
 |  |  |  |  |  |  |  |  |  | 136|ABC7
 |  |  |  |  |  |  |  |  |  | 137|ABC1
 |  |  |  |  |  |  |  |  |  | 137|ABC2|12
 |  |  |  |  |  |  |  |  |  | 137|ABC3|10
 |  |  |  |  |  |  |  |  |  | 137|ABC4
 |  |  |  |  |  |  |  |  |  | 137|ABC5
 |  |  |  |  |  |  |  |  |  | 137|ABC6|12
 |  |  |  |  |  |  |  |  |  | 137|ABC7|12
 |  |  |  |  |  |  |  |  |  | 138|ABC1|10
 |  |  |  |  |  |  |  |  |  | 138|ABC2
 |  |  |  |  |  |  |  |  |  | 138|ABC3
 |  |  |  |  |  |  |  |  |  | 138|ABC4|18
 |  |  |  |  |  |  |  |  |  | 138|ABC5|15
 |  |  |  |  |  |  |  |  |  | 138|ABC6|13
 |  |  |  |  |  |  |  |  |  | 138|ABC7|16
 |  |  |  |  |  |  |  |  |  | 139|ABC1
 |  |  |  |  |  |  |  |  |  | 139|ABC2|13
 |  |  |  |  |  |  |  |  |  | 139|ABC3|14
 |  |  |  |  |  |  |  |  |  | 139|ABC4|12
 |  |  |  |  |  |  |  |  |  | 139|ABC5|14
 |  |  |  |  |  |  |  |  |  | 139|ABC6|13
 |  |  |  |  |  |  |  |  |  | 139|ABC7|18