Forum Discussion
Filter Function error
Hello,
=FILTRE($E$2:$E$6;$D$2:$D$6=A6)#EPARS! seems to be the #SPILL! error. You can try to delete the #CALC! error in cell B7 and the formula should return the expected result.
- Hi Quadruple_Pawn, #EPARS! is in french for #SPILL! error. You are right when I deleted #CALC! error in cell B7 I have the correct result but not in B6 as expected but in B7.
Does this mean you expect 38338367 as the only result for E.BRITO - 2018-06 - ENG.43A00 - 3,5?
E.BRITO - 2018-06 - ENG.43A00 - 3,5 is in cells D4 and D6 with different values in cells E4 and E6 and therefore has to return both invoice numbers according to my expectation.
Is there any additional criteria if you only want to return 38338367?
- I expected to have have as result 38338367 in B6 since one of the line in B3 and B4 was credited an reinvoinced as shown in E5 and E6, the credited is right but not the reinvoiced line, it is returning 38301175 instead of 38338367 in B6
