Forum Discussion
Solved
Excel Filter() Function Skipping Data
Hello all! I am completing an analysis based on a very large master data set (around 50.,000 rows). I have encountered an issue in one specific calculation I am trying to program. Basically, a p...
- Never mind. I just found the issue. The sheet where I input my test formula had filters present, which meant that rows 3-5 and 7 were hidden and that is where the filtered data would populate.
Added note, I have just found the F9 function for in-formula testing. Even the formula : =FILTER({2232,1;0;0;0;0;0;0};{TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE};0) still only gives me two results: 2232,1 and 0.
Never mind. I just found the issue. The sheet where I input my test formula had filters present, which meant that rows 3-5 and 7 were hidden and that is where the filtered data would populate.