Forum Discussion

Copper Contributor

Jan 21, 2022

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...

excel

Formulas and Functions

Riny_van_Eekelen
Jan 21, 2022
abrummet That could be like in the picture below.
File attached.
Book2.xlsx10 KB

Riny_van_Eekelen

Platinum Contributor

Jan 21, 2022

abrummet That could be like in the picture below.

File attached.

Book2.xlsx10 KB

abrummet

Copper Contributor

Jan 21, 2022

Additionally, I simply embedded the two initial filter functions into the filter and xlookup combo and that worked wonderfully. So this is condensed down into 1 equation. Thanks!