Here's a formula solution:
Data in A2:C8
E2 = 10.1.2005
F2 = David
Enter this formula in G2 as an array using the key combo of
CTRL,SHIFT,ENTER:
=IF(SUMPRODUCT(--($A2:$A8=$E2),--($B2:$B8=$F2))=COLUMNS($A:A),INDEX($C2:$C8,SMALL( IF(($A2:$A8=$E2)*($B2:$B8=$F2),ROW(C2:C8)-ROW(C2)+1),COLUMNS($A:A))),"")
Copy across until you get blanks.
Biff
"skarbanan" wrote
in message ...
I have tjis problem that is killing me.
I have this:
DATE | USER | CAR
------------------
5.1.2005 | MARK | LINCOLN
6.1.2005 | JOHN | LINCOLN
8.1.2005 | JOHN | LINCOLN
10.1.2005 | DAVID | LINCOLN
11.1.2005 | JIM | LINCOLN
10.1.2005 | DAVID | BMW
10.1.2005 | DAVID | MERCEDES
How do i get the results regarding DAVID?
Like this:
10.1.2005 | DAVID | LINCOLN | BMW | MERCEDES
When i use Vlookup i get only the first result,or if i put true at the
end of the Vlookup gormula it gives a wrong result.
Please help me!
--
skarbanan
------------------------------------------------------------------------
skarbanan's Profile:
http://www.excelforum.com/member.php...o&userid=29901
View this thread: http://www.excelforum.com/showthread...hreadid=496084