Thread: Need a Single list of names from 4 columns, no duplicates

I have a range of names "AQ3:AT37". Their are duplicate names in the range and while their are no gaps in each column list, each column is not a full 35 names long, they all vary around 20 some names each. Starting at "AU3" I want to produce a single column list with no duplicates.

Thanks.

Jim O

Arrayformula; Ctrl+Shift+Enter, not only Enter.

=if(iserror(indirect(text(min(if(isnumber($aq$3:$at$37)-isblank($aq$3:$at$37)+countif($au$2:$au2,$aq$3:$at$37),"^^",row($3:$37)*1000+column(aq$1:at$1))),"r0c???"),)),"",indirect(text(min(if(isnumber($aq$3:$at$37)-isblank($aq$3:$at$37)+countif($au$2:$au2,$aq$3:$at$37),"^^",row($3:$37)*1000+column(aq$1:at$1))),"r0c???"),))

Jim,

For Excel 2007 or higher.

=IFERROR(INDIRECT(TEXT(MIN(IF(ISNUMBER($AQ$3:$AT$37)-ISBLANK($AQ$3:$AT$37)+COUNTIF($AU$2:$AU2,$AQ$3:$AT$37),"^^",ROW($3:$37)*1000+COLUMN(AQ$1:AT$1))),"R0C???"),FALSE),"")