Identifying last record (de-duping)

Apologies as this will be a bit rushed and no attachment example, but it's quite a straightfoward query (which I've performed before but my mind has gone blank).

I have a file of customer queries dealt with by a particular member of staff from our database. Some of them have multiple entries, if they have been passed to that member of staff more than once. Every time it is allocated to another member of staff, the record is annotated with a sequential 'Log' number. So the first few records read as follows (Enquiry number and log number only)

Enquiry Number log
19 1
19 2
186 5
187 1
187 2
187 3
187 4
187 5
206 1
206 2
206 3

I wish to identify the last time each one was allocated to this member of staff, so I would end up with:

19 2
186 5
187 5
206 3

What's the easiest way?

Thanks

Another way would be to use
=LOOKUP(2,1/($A$1:$A$11=D1),$B$1:$B$11), where D1 has the first of your unique values list from A.

Great, that's given me what I wanted in terms of unique id and last log. Next question, I have other columns which I didn't include on the example. Can I incorporate these onto my pivot table or will I have to take the data from the pivot table and do a look up on my original sheet?
Thanks

Originally Posted by DonkeyOte

You'll need to elaborate on

a) what those "columns" are exactly

b) what you want to do with a)

I've attached 2 files, a test one and test results, to show what I want to return.

Thanks

Great, I'll have a go at that
Thanks