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
https://drive.google.com/open?id=0B-aRVOFiYSq3WG1TenF4M1JsQUU
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
ok
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
yes
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
https://docs.google.com/spreadsheets/d/1SHJTVAFdbP8WThAKiDKWxTsxkRi9sJDbdrtilFZ-krg/edit?usp=sharing
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. :(