Querying a range returned by another function

[Bill Steamshove]

I have a log file that has three columns in it: User ID, Action, Date
There are multiple entries of the same User ID and what I would like t
do is present the data in the following so there is a single row fo
each User ID followed by the dates of specific Actions by that user
User ID, Action 1 Date, Action 2 Date, etc

I've sorted the data by User ID, now I want to get a range back of eac
users actions and do a lookup for each action to get the correspondin
dates.

I'm having a lot of trouble producing the formula. Could I get a han
please

 

[Ardus Petus]

Use following formula in resulting cells:
=SUMPRODUCT(($A2=Sheet1!$A$2:$A$99)*(B$1=Sheet1!$B$2:$B$99)*Sheet1!$C$2:$C$9
9)

See example: http://cjoint.com/?ejrSpzlFAs

HTH
--
AP

"Bill Steamshove"
<[email protected]> a écrit dans
le message de
news:[email protected]...

 

[Bill Steamshove]

That's perfect! Thanks for your help.