Basically, I have a table with about 30-40 columns. I'd like to create a filter with criteria but only return a few rows of the full source table.
here is an example
Current formula returns the entire table
=FILTER(Table1,Table1[TOTAL]>200)
Can the Table1 argument specify to only return specific columns?
This didn't work but hopefully explains my question.
=FILTER(Table1[PRODUCT]&Table1[TOTAL],Table1[TOTAL]>200)
here is an example
PRODUCT | EAST | WEST | SOUTH | NORTH | TOTAL |
a | 67 | 61 | 76 | 21 | 225 |
b | 23 | 10 | 43 | 88 | 164 |
c | 86 | 96 | 99 | 34 | 315 |
d | 56 | 74 | 23 | 67 | 220 |
e | 35 | 90 | 8 | 49 | 182 |
f | 93 | 2 | 5 | 76 | 176 |
g | 74 | 6 | 91 | 98 | 269 |
h | 10 | 72 | 4 | 31 | 117 |
i | 36 | 76 | 45 | 70 | 227 |
Current formula returns the entire table
=FILTER(Table1,Table1[TOTAL]>200)
Can the Table1 argument specify to only return specific columns?
This didn't work but hopefully explains my question.
=FILTER(Table1[PRODUCT]&Table1[TOTAL],Table1[TOTAL]>200)