Peter Davison
Active Member
- Joined
- Jun 4, 2020
- Messages
- 444
- Office Version
- 365
- Platform
- Windows
I have this formula below which looks at 52 columns and I enter a 1 if I want it to show the column or a 0 if I don't
Is there any way instead of manually changing 1's to 0's I can get it to read the 1 or 0 from a cell address
I did try to replace a zero with a cell address (say D11) but it did not like that, also tried indirect and isnumber, also changed to 1 and 0 to True or False but nothing worked
=FILTER(Stores!$A$8:$AZ$4998,{1,1,1,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0})
Thank you for your help.
Is there any way instead of manually changing 1's to 0's I can get it to read the 1 or 0 from a cell address
I did try to replace a zero with a cell address (say D11) but it did not like that, also tried indirect and isnumber, also changed to 1 and 0 to True or False but nothing worked
=FILTER(Stores!$A$8:$AZ$4998,{1,1,1,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0})
Thank you for your help.