How to autopopulate and group companies by name?

Liziz

New Member
Joined
May 17, 2021
Messages
1
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2013
Platform
  1. Windows
Hello!

Hoping an excel whiz will be able to help me.

I have a spreadsheet with multiple tabs which has line items of company names (the names are often repeated). I need to create a column to group these companies i.e. any line items with the company JPMC mentioned automatically populate the new column as 'group 1', any lines with the company name IBM populate as 'group 2' and with the name Apple populate the new column as 'group 3'. I've added an image as an example to put into context what I'm after.

This is a very simplified version of the doc I'm working on. The column that has the company name is often followed by other text and information so I need a formula that specifically isolates the company name.

I'm hoping there's some formula or macros that can be used so it either automatically populates down the column/across tabs or can be dragged down to populate easily.

Not sure if this is possible but any help with be appreciated. I've tried using the IF and TRUE formula but it only seems to work on one cell. I can drag it or copy it.

Thank you!
 

Attachments

  • EXCEL EXAMPLE.JPG
    EXCEL EXAMPLE.JPG
    71.6 KB · Views: 9

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

Forum statistics

Threads
1,140,999
Messages
5,703,645
Members
421,307
Latest member
morrden86

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top