Further to Special-K's answers, here's how to get the list of unique names in column G.
With your data starting on row 2 (that's important - if it starts on row 1 this won't work) and going down to row 5, put this in G2:
Formula:
=INDIRECT(TEXT(MIN(IF(($A$2:$D$5<>"")*(COUNTIF($G$1:G1,$A$2:$D$5)=0),ROW($2:$5)*100+COLUMN($A:$D),7^8)),"R0C00"),)
Important: this is an array formula so needs to be entered using Ctrl-Shift-Enter not just Enter. You will know the array is active when you see curly brackets { } appear around your formula - don't try to enter them yourself. If you do not Ctrl-Shift-Enter an array formula you will get an error or a clearly incorrect result. If that happens, just click into the formula bar and try again.
Drag it down until you start getting zeroes. You can get rid of the zeroes by adding &"" to the end of the formula:
Formula:
=INDIRECT(TEXT(MIN(IF(($A$2:$D$5<>"")*(COUNTIF($G$1:G1,$A$2:$D$5)=0),ROW($2:$5)*100+COLUMN($A:$D),7^8)),"R0C00"),)&""
Now you'll get blanks after the list of names.
Hope that helps - combined with the answers above.
Edit: by the way, when I say 'unique' above, what I actually mean is 'distinct'. 'Unique' means 'values which appear once and once only' whilst 'distinct' means 'all values which appear at least once' - in other words, distinct includes values which appear twice or more, whilst unique would exclude any values which appear more than once.
Bookmarks