I am trying to extract the unique names of every company listed on the following Fortune 500 index since 1955. Many names are repeated since they stayed in the index for years at a time. The only function I can find in Google Sheets is UNIQUE, but it only works on single columns, not entire datasets. Any suggestions?

CodePudding user response：

Use FLATTEN() with UNIQUE() function.

=UNIQUE(FLATTEN(B2:U))