mart_mrexcel
Active Member
- Joined
- Aug 23, 2008
- Messages
- 295
- Office Version
- 365
- Platform
- Windows
I have 2 filter result coming from different table and i wanted to combine them in one column
Example
1.) From Table 1 --> FILTER(FILTER(BPOT[[Cost Center]:[SAP Company Code]],BPOT[SAP Company Code]=Sheet1!A5),{1,0})
2.) From Table 2 --> =FILTER(FILTER(ActualOT[[Company Code]:[Cost Center]],ActualOT[Company Code]=Sheet1!A5),{0,1})
Thanks
Example
1.) From Table 1 --> FILTER(FILTER(BPOT[[Cost Center]:[SAP Company Code]],BPOT[SAP Company Code]=Sheet1!A5),{1,0})
2.) From Table 2 --> =FILTER(FILTER(ActualOT[[Company Code]:[Cost Center]],ActualOT[Company Code]=Sheet1!A5),{0,1})
Thanks