![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(99.2, 55.00000000000001%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
Microsoft 365 and Office | Excel | For business | MacOS
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 56.00000000000001%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
Hi Kevin,
Regarding your concern, there is currently no separate official master list from Microsoft including all the industries used by the Stocks linked data type. To view the industry assigned to a stock linked in cell A2, please use this formula =A2.Industry.
You can also type =A2. to see all fields available for that stock. The underlying company information is provided by LSEG Data & Analytics, which maintains the classifications.
If you have multiple stocks, you can extract their industries into a column and use UNIQUE to create a list of the industries represented in your workbook.
Hope this will help. Should you have any other questions, please feel free to share them in the comments of this post. I'm happy to assist you further.