Jul 30 2022 07:55 PM
Jul 30 2022 10:01 PM
Hi @Eliecer
It's highly probable that values in A6 and D6 don't compare (i.e. extra space(s) in one of them). To check, in an empty cell enter =D6=A6
If you get FALSE this confirms the values don't compare. If you get TRUE then please share your sample workbook & explain where the data in D2:E6 come from (i.e. copy/paste from a Web page)
Jul 31 2022 04:05 AM
=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.
Jul 31 2022 07:36 AM
Jul 31 2022 08:00 AM
Jul 31 2022 08:13 AM
Jul 31 2022 12:42 PM
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?
Jul 31 2022 04:16 PM