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...
Thanks. I see what you are doing there and that makes sense; however, it doesn't quite work for what I am wanting to do. The xlookup embedded in the filter function is essentially just finding the difference between the two lists with no connection to the number associated with that person. I am trying to find the difference between the two list for everyone that has a certain number associated with them. Meaning, who is a "1" on the first list and who is a "1" on the second list, and now what is the difference between them. Any thoughts on this? Thanks again.
unless I spoke too soon. I see now you did the filter for both and then the embedded xlookup and filter. This works! Thank you and I apologize for the confusion