Forum Discussion
Solved
difference between two filtered lists in excel
Hi, I have two lists and I want to compare between them. However, I only want to compare between certain portions of each list. What I am really looking for is the difference between 2 filter functi...
Riny_van_Eekelen
=FILTER(A:A,XLOOUP(A:A,B:B,B:B,X)=X)
Could X be any number? As I test 0,10,100... ^O^
=FILTER(A:A,XLOOUP(A:A,B:B,B:B,X)=X)
Could X be any number? As I test 0,10,100... ^O^
Benny_1857 I guess so. The "X" inside the XLOOKUP is what get's returned when the lookup value is not found. Then, with FILTER you can specify the "X" to be the inclusion criteria.