Showing only new data between two sheets

Question

Thanks in advance for anyone who can help.

I have two sheets of information, and I want to compare the two but be able to filter and pull out only the new data that does not appear on the second sheet.

For example: Our inventory system doesn't have a date range search function. So I have a list of instrument serial #'s that were available as of September 1st and another list that were available as of November 1st. Is there a way to compare the sheets and see what serial #'s only appear on the November 1st sheet in order to show only the new instruments added since Sept 1st?

Any help is greatly appreciated.

Answer 1

I found an answer using Conditional formatting. Thanks!

Answer 2

I tried this, and it returned "New" in each cell of Column B, even next to serial #'s that appear on both lists.

Answer 3

Hi Rental,

Thanks for contacting us,

Assuming that your serial numbers are in column A of both sheets, and that the sheet names are "Sept 1st" and "Nov 1st", you can use the following formula in cell B2 of the "Nov 1st" sheet:

=IF(ISNA(MATCH(A2,'Sept 1st'! A:A,0)),"New","")

This formula will check if the value in cell A2 of the "Nov 1st" sheet is found in column A of the "Sept 1st" sheet. If not, it will return "New" in cell B2. If yes, it will return an empty string. You can copy this formula down to the rest of the column B.

Then, you can filter the column B by the value "New" to show only the new serial numbers that were added since Sept 1st.

You can also use other methods to compare two Excel sheets, such as using the View Side by Side option, the Compare Sheets add-in, or the conditional formatting feature. https://trumpexcel.com/compare-two-excel-sheets/ ***Note: This is a non-Microsoft website. The page appears to be providing accurate, safe information. Watch out for ads on the site that may advertise products frequently classified as a PUP (Potentially Unwanted Products). Thoroughly research any product advertised on the site before you decide to download and install it.***

I hope this helps!

Regards, Sola