Excel - COLUMN Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I need to analyze data in this file. Companies’ column A and part in column F. Which companies have both Part A and Part B, Which have only Part A, which have only Part B. Top 10 Part A companies.
Solved by Z. E. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
User 20/07/2017 - 09:39
Excelchat Expert 20/07/2017 - 09:40
Thank you. One moment.
Excelchat Expert 20/07/2017 - 09:41
Can you give me an example of what you need?
Excelchat Expert 20/07/2017 - 09:41
I have the file open and can see the company names and parts
User 20/07/2017 - 09:41
I want to find companies that have both Part A and Part B
User 20/07/2017 - 09:41
Those that have only Part A
User 20/07/2017 - 09:42
Top 10 companies Part A
User 20/07/2017 - 09:42
by $ amount in column G
Excelchat Expert 20/07/2017 - 09:44
Alright, we have a policy of 1 question per 20 minutes session so I will be able to help you with your initial request but I may have to ask you to repost your question later for the other questions. I hope you understand that I just don't want to get into trouble.
Excelchat Expert 20/07/2017 - 09:44
Now we can continue into the explanation step of this session. I am going to perform the following:
Excelchat Expert 20/07/2017 - 09:44
I'll analyze your data and figure out the best way to check which companies have both parts.
User 20/07/2017 - 09:45
Excelchat Expert 20/07/2017 - 09:49
Alright, I think the best and easiest way to figure our which companies have both parts is with a use of Pivot Tables.
Excelchat Expert 20/07/2017 - 09:49
Are you familiar with Pivot Tables?
User 20/07/2017 - 09:49
Excelchat Expert 20/07/2017 - 09:50
Okay, I'm going to try something on my end and then send you a copy of the report back.
User 20/07/2017 - 09:50
ok, thanks
Excelchat Expert 20/07/2017 - 09:55
Alright, we are running out of time. Please click this link where we can continue chatting for a few minutes after the timer runs out.
User 20/07/2017 - 09:55
ok send the link
Excelchat Expert 20/07/2017 - 09:55
Excelchat Expert 20/07/2017 - 09:57
Sorry for the delay, there's too much data in the worksheet you sent and my Excel is barely able to keep up with it.
Excelchat Expert 20/07/2017 - 09:57
It just crashed. :(
Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc