Aug 20 2021 06:31 PM
Aug 21 2021 03:07 AM
Aug 21 2021 03:17 AM
Unfortunately you didn't mention on which version of Excel you are.
To check duplicates you may apply conditional formatting rule to each of ranges
Names which are not in B1:B6 and E1:E6 - add in H1 formula
=IFERROR(INDEX(Sheet2!$A$1:$A$15, AGGREGATE(15,6, 1/(COUNTIF($E$1:$E$6,Sheet2!$A$1:$A$15)=0)/ (COUNTIF($B$1:$B$6,Sheet2!$A$1:$A$15)=0)* ROW(Sheet2!$A$1:$A$15), ROW())),"")
and drag it down till empty cells appear.
If range starts not from first row of the sheet formula is to be modified, except range
ROW() - ROW(cell before start)
at the end.
In attached file they are applied to the first and last blocks.