Comparison chart with two tables

[kenny_kk]

Hello there, help required

Am currently in my first day in analytics and I'm struggling to get the data to be compared to make it in a chart form. Say that I'm trying to compare my company's value to the industry's value.


Entire industry
Industry - Values
A - 246
B - 135
C - 123
D - 678
E - 250
...
Z - 789

My company
[B]Industry - Values
A - 250
C - 185
E - 200
...
Y - 520

The funniest part, is that 'My Company' do not have all the fields (say, 'B' and 'D' in the table), hence I'm unable to easily sort it and paste it next to the 'Industry' table, and I'm currently not sure which function/formula should I use, so that the column next to 'My Company' will be able to capture the ONLY necessary information from 'Industry' table, to be generated into a comparison chart. As the rows are almost 60+, it's almost impossible to make the table manually.

To make it easily, my outcome would be this;

Industry - Company comparison

Industry - Company
Industry - Company
A - 246 - 250
C - 123 - 185
E - 250 - 200
...

Help?

[kenny_kk]

For a better understanding of what I was referring.
Picture
Attachment 426599

Excel file
Book_SampleValue.xlsx

[stasinek]

Hi,
My suggestion in the appendix

[kenny_kk]

Hi,
My suggestion in the appendix

Thanks a lot, I've noticed that you've used the SUMPRODUCT function.
But how do I replicate the steps?
When I got to SUMPRODUCT Function, there are Array1, Array2 and Array 3, how do I go about it?

[stasinek]

Analyze the formula at a normal table