Quote:
Originally Posted by xor
That's really quite a complication.
Will see, but not at all sure if I can come up with anything useful.
|
How were you able to do the date? Was it based literally on most recent date (and therefore not work for the other columns?).
The other option I was thinking is for each record to have a unique call ID and if the recent date is for that record then do a lookup using the ID. But not sure how I would bring the ID in to perform the v lookup.
Other option I was thinking was to then do a vlookup and be required to match the company name and date (and possibly time if it would make it more accurate as I will have a timestamp for each record?)