See this screencap:

http://img104.imageshack.us/img104/8...reencapdg3.jpg

The easiest way to do this is to put the formula on the same sheet like I
did and then after you have the table completed cut and paste it to the
other sheet. That way you don't have to mess around with sheet names and
flipping between sheets as you write the formula.

Biff

"rerhart" wrote in
message ...

I have 2 sheets in workbook. On sheet1 I have values in 2 columns, such
as:

Name Type
test1 A
test2 B
test3 A
test4 A
test5 B

On sheet2 I would like to summarize the information by Type, such as:

TypeA TypeB
test1 test2
test3 test5
test4

What formula can I configure on sheet2 to acquire this result?
Thanks!


--
rerhart
------------------------------------------------------------------------
rerhart's Profile:
http://www.excelforum.com/member.php...fo&userid=8138
View this thread: http://www.excelforum.com/showthread...hreadid=570905