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 to
do is present the data in the following so there is a single row for
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 each
users actions and do a lookup for each action to get the corresponding
dates.

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


--
Bill Steamshove
------------------------------------------------------------------------
Bill Steamshove's Profile: http://www.excelforum.com/member.php...o&userid=33309
View this thread: http://www.excelforum.com/showthread...hreadid=531322