I posted an earlier question looking for a formula to use to find which names that are in column 2 but not column 1. The problem I ran into is that column 1 and column 2 are filtered columns. I have applied a filter so what is showing is let’s say 30 names but the original spreadsheet has 100 names. When using the functions suggested they continued to use the entire unfiltered spreadsheet instead of what I was seeing on my filtered view. What can I do thanks in advance!!!