Extract unique values but also exclude names from another column

[alirezae90]

Hi everyone,

I have a list of names on E10:E1000 and I am creating a list of unique values on this list using the function below.

=IFERROR(INDEX(!$E$10:$E$1000, MATCH(0,COUNTIF($C$16:C16,!$E$10:$E$1000), 0)),"")

However, I would like to exclude from this list a range of names that are in column C3:C10.

Can anyone help on amending the above formula to create a dynamic list of unique names that would exclude the names in column C3:C10?

Many thanks,

 

[Marcelo Branco]

Try

=IFERROR(INDEX($E$10:$E$1000, MATCH(0,IF(E$10:E$1000<>"",ISNUMBER(MATCH(E$10:E$1000,C$3:C$10,0))+COUNTIF($C$16:C16,$E$10:$E$1000)), 0)),"")
Ctrl+Shift+Enter

Hope this helps

M.