•2 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
The Excel filter formula returns #value! as the result.
Hello
I have created a table with product codes and the weeks in which they will be on promotion.
What I would like to do is extract, for a given week (Output), all the codes present in that week marked with an X.
The formula I have entered is this:
=FILTER(A2:A5;BYROW(FILTER(B2:E5;1-ISNA(XMATCH(B1:E1;I2));‘’)=‘X’;“”);‘’)
However, it gives me an error: #VALUE!
Can anyone tell me what is wrong?
| KW1 | KW2 | KW3 | KW4 | KW5 | Input | |||
|---|---|---|---|---|---|---|---|---|
| H2351 | X | X | Select KW | KW2 | ||||
| Z4074 | X | X | ||||||
| X2348 | X | X | X | X | ||||
| J4333 | X | X | Ouptut | #VALORE! |
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#financial modeling with spreadsheets
#AI formula generation techniques
#Excel compatibility
#rows.com
#formula generator
#Excel alternatives
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel
#filter formula
##VALUE!
#product codes
#promotion
#codes
#extract
#weeks
#BFILTER
#BYROW
#FILTER