I have a file with several sheets, sheet 1 has the name in column H,
color code in column J and units in column N as below:

col H
Vehix
Vehix
Vehix
Conci

col J
97
87
25
97

col N
1800
2400
3600
1800
On sheet 2 I want to reference this data and create a summary of color
codes, in column A I want to list the Names of all but only list the
name once, in columns b through z, row 2 I want to list the color codes
as below:


col A
Vehix
Conci

col b
25

col c
87

col d
97

I will hard key the color codes on sheet 2, I want to create a formula
to list the each name once, and a formula to sum up the color code
total units for each style.

What is the formula to list the name once?

What is the formula to lookup the color code for the styles?

Thanks.


--
JR573PUTT
------------------------------------------------------------------------
JR573PUTT's Profile: http://www.excelforum.com/member.php...o&userid=31587
View this thread: http://www.excelforum.com/showthread...hreadid=527848