Xlookup or other formula help for copying data over but excluding specific data
I have sheet A that has 3000 rows of data, and I have sheet B that has 1000 rows of data. I want to copy all data from sheet A to a new sheet, sheet C, but exclude all rows that are in Sheet B. Sheet B consists of data that is in sheet A that I do not want in there so I’m not sure the best way to exclude/filter that sheet B data out. Any help is appreciated, thank you!
i.e. if sheet C includes any data from sheet B, remove/do not include that row.
I have sheet A that has 3000 rows of data, and I have sheet B that has 1000 rows of data. I want to copy all data from sheet A to a new sheet, sheet C, but exclude all rows that are in Sheet B. Sheet B consists of data that is in sheet A that I do not want in there so I’m not sure the best way to exclude/filter that sheet B data out. Any help is appreciated, thank you! i.e. if sheet C includes any data from sheet B, remove/do not include that row. Read More