Hi
if you have your dates and names filled on sheet 2 put the following
formula in B2:
=SUMPRODUCT(--('sheet1'!$A$1:$A$1000=B$2),--('sheet1'!$B$1:$B$1000=$A2)
,'sheet1'!$C$1:$C$1000)

and copy across


--
Regards
Frank Kabel
Frankfurt, Germany


Hi Guys!

I need help again... I don't really know how to explain it by words
so
I'll be explaining what I need by examples... Hope you'll get what I
mean...


For example I have the following data in Sheet2

DATE - NAME - SALES
8/1 - Paul - 10
8/1 - Gina - 23
8/1 - Lester - 65
8/1 - June - 12
8/1 - Lex - 8
8/2 - Paul - 6
8/2 - Gina - 1
8/2 - Ester - 4
8/3 - Paul - 8
8/3 - Gina - 5

How can I create a report in another sheet that something looks like
this:

-----------------------------------------------------------|
NAME----------- |--- 8/1---- |--- 8/2----|--- 8/3----|
-----------------------------------------------------------|
Paul-------------|----10------|----6-------|----8------|
-----------------------------------------------------------
Gina-------------|-----23-----|-----1------|-----5-----|
-----------------------------------------------------------
so on and so forth...

Do you know how to do this without using Pivot?

I also attached here a sample of data... I have two sheets there..
the
Raw and Summary

Thanks for all the help!


Arj

Attachment filename: sample.xls
Download attachment:
http://www.excelforum.com/attachment.php?postid=647311 ---
Message posted from http://www.ExcelForum.com/