Hi all,
In sheet1, I have a column with company names listed multiple times and I need to show the company names in sheet2 by alphabetical order in one row with each company listed in a separate column, up to 10 columns. I made the column that the names are in a table (table3) and used countif to get a unique count on sheet2 shown here: =INDEX(table3,MATCH(0,INDEX(COUNTIF($S$11:U11,table3),),0)). This works well until sheet1 is sorted, then the company names in the columns move around. The names need to be fixed on Sheet2 because there's other data below the company name in each column that correspond to each company.
Thanks,
LK
In sheet1, I have a column with company names listed multiple times and I need to show the company names in sheet2 by alphabetical order in one row with each company listed in a separate column, up to 10 columns. I made the column that the names are in a table (table3) and used countif to get a unique count on sheet2 shown here: =INDEX(table3,MATCH(0,INDEX(COUNTIF($S$11:U11,table3),),0)). This works well until sheet1 is sorted, then the company names in the columns move around. The names need to be fixed on Sheet2 because there's other data below the company name in each column that correspond to each company.
Thanks,
LK