Dynamically extract unique records to a horizontal column header with formula Offset?

[DavisNRJr]

Is there a way to do this,

=IFERROR(INDEX('[Import A Clean Master Parts File QG.xlsm]A Master Clean Master Parts Fil'!$F$5:$F$59,MATCH(0,COUNTIF($A1:A1,'[Import A Clean Master Parts File QG.xlsm]A Master Clean Master Parts Fil'!$F$5:$F$59),0)),"")

using the offset function so that the header list will grow dynamically if numbers are added to the list?

 

[Joe4]

Duplicate: http://www.mrexcel.com/forum/showth...ds-to-a-horizontal-column-header-with-formula

Please do not start multiple threads on the same topic. Per forum rules, such threads will be locked or deleted (see rules #9 here: http://www.mrexcel.com/forum/showthread.php?99490-Forum-Rules). All clarifications, bumps, or directly related follow-ups should be posted to the same thread. Please only start new threads with new questions/topics.