Matching Data from Common Column

[somebody113]

Table 1

7/4/2011	AMWG16=01BLK25K_USA[a3]*042711	Date a Rich Black Man By June 23	235	0	$0.19 	http://www.jyxsaw.com/blackrm/index.php?t202id=2676&t202kw=AMWG16=01_0210-3
7/4/2011	AMWG16=01BLK25K_USA[a3]*042711	Date a Rich Black Man By June 23	250	0	$0.20 	http://www.jyxsaw.com/blackrm/index.php?t202id=2676&t202kw=AMWG16=01_0212-16
7/4/2011	AMWG16=01BLK25K_USA[a3]*042711	Date a Rich Black Man By June 23	260	1	$0.21 	http://www.jyxsaw.com/blackrm/index.php?t202id=2676&t202kw=AMWG16=01_0214-7
7/4/2011	AMWG16=01BLK25K_USA[a3]*042711	Why Settle? Date Rich Black Men!	344	0	$0.28 	http://www.jyxsaw.com/blackrm/index.php?t202id=2676&t202kw=AMWG16=01_0208-9
7/4/2011	AMWG16=01BLK25K_USA[a3]*042711	Why Settle? Date Rich Black Men!	329	1	$0.27 	http://www.jyxsaw.com/blackrm/index.php?t202id=2676&t202kw=AMWG16=01_0209-10
7/4/2011	AMWG16=01BLK25K_USA[a3]*042711	Why Settle? Date Rich Black Men!	362	0	$0.29 	http://www.jyxsaw.com/blackrm/index.php?t202id=2676&t202kw=AMWG16=01_0211-20
7/4/2011	AMWG16=01BLK25K_USA[a3]*042711	Date a Rich Black Man By June 23	230	0	$0.19 	http://www.jyxsaw.com/blackrm/index.php?t202id=2676&t202kw=AMWG16=01_0212-16

Table 2

AMWG16=01_0212-16	26	5	19.23%	$3.50 	$0.67 	$0.05 	$17.50 	$1.30 	$16.20 	1246.00%
AMTD03=02_0041-16	26	1	3.85%	$3.40 	$0.13 	$0.05 	$3.40 	$1.30 	$2.10 	162.00%
BMFG01=01_0021-21	25	4	16.00%	$4.00 	$0.64 	$0.05 	$16.00 	$1.25 	$14.75 	1180.00%
AMWG16=01_0211-20	13	3	23.08%	$3.50 	$0.81 	$0.05 	$10.50 	$0.65 	$9.85 	1515.00%

Hey guys, I've got two tables of information here, if you scroll to the far right of table 1 and look at the left of table two, you'll see a common code like:

AMWG16=01_0211-20
AMWG16=01_0212-16

and these entries will appear multiple times as well

AMWG16=01_0212-16

appears twice and the data is different and will need to be added up

How can I:


1. Add up the data on each table with the common string such as "AMWG16=01_0212-16"

2. Take all the data that has been added up and combine the statistics, for example,
when its all done it should show

AMWG16=01_0212-16

in the first column, and then all the statistics from the two tables in the columns to the right.

I'm guesssing...

Since some entries appear multiple times, you will need to sum up all the unique entries for that value. Say:

AMWG16=01_0211-20

Shows up three times, you'll need to sum up all the values and this needs to be done on both tables

THEN

You can combine the data

I'm familiar w/ vlookup, index, match functions, but I'm not quite sure how to put this all together, thanks for the help!!

 

[GlennUK]

If you are just wanting to sum data from the first table, with a formula in the second table that sums only for a particular code, then I'd say that SUMIF should do it.

 

[somebody113]

Hey Glenn,

I've attached the sheet with the two tables below for more clarification, it's below, thanks for the help!!

www.jyxsaw.com/excel/matching.xlsx

 

[GlennUK]

So, something like:

=SUMIF('Table 1'!$G$1:$G$11100,"=*"&'Table 2'!A1,'Table 1'!$F$1:$F$11100)

maybe?

 

[somebody113]

Simple Export Not Working - Advice?

sry, wrong spot