Extract values from a range that are missing from another
Solution 1:
There is no built-in function that can singlehandedly do this task.
You can try this array formula in the "Not Here" column (MS Excel 2007+)
=IFERROR(INDEX(roster,SMALL(IF(COUNTIF(present,roster)=0,ROW()-1,""),ROW()-1),1),"")
Where (in my example)roster is a Named Range that refers to $A$2:$A$21present is a Named Range that refers to $B$2:$B$21
To enter the formula, select the cells in the Not Here column (in my case it's C2 down to C21), type the formula and then press Ctrl+Shift+Enter
