Index Match Small Rows - Trying to return w/out blanks

[tryingtoexcelatexcel]

Hi All,

Please see the attached file here.

I have new data (pivot table) and old data (copied from last week's pivot table) and I want to see what old data is still there (old) and what is new.

The formula I am using is: =INDEX($E$6:$E$500,SMALL(IF(INDEX($E$6:$E$500,MATCH(E6,$B$6:$B$500,0))=E6,ROW($E$1:$E$500)),ROWS($6:6)))

and it is an array formula

So the formula is not working and I am not sure why, any help would be very much appreciated.