Find if value exists multiple times or is new value

Formula in D:

Formula:

Please Login or Register  to view this content.

For E change ranges between them in formula above.
For F:

Formula:

Please Login or Register  to view this content.

is Array, so Ctrl+Shift+Enter instead of regular Enter.
But this will make your file slow. Instead, you could use something like this: https://www.ablebits.com/office-addi...omment-page-1/

They can be simplified a little (but not much!!):

=IFERROR(INDEX($A:$A,AGGREGATE(15,6,ROW($A$2:$A$2000)/(($A$2:$A$2000<>"")*(ISNA(MATCH($A$2:$A$2000,$B$2:$B$2000,0)))),ROWS($1:1))),"")

and

=IFERROR(INDEX(B:B,AGGREGATE(15,6,ROW($B$2:$B$2000)/(($B$2:$B$2000<>"")*(ISNA(MATCH($B$2:$B$2000,$A$2:$A$2000,0)))),ROWS($1:1))),"")

and

=IFERROR(INDEX($B:$B,AGGREGATE(15,6,ROW($B$2:$B$2000)/($B$2:$B$2000<>"")*(NOT(ISNA(MATCH($B$2:$B$2000,$A$2:$A$2000,0)))),ROWS($1:1))),"")

The advantages are: a) the ranges are not exact, any sensible number greater than the no of rows will do, and b) all 3 are non-array formulae (just use enter).