Automatically skip "inactive" cells

[Brouwerjr]

Hi,

Can someone please help me with attached issue.
I'm using a bigger version of that template to monitor daily who is doing what and add new lines when there are any changes. I also use that info to create reports at the end (of the day/week/month).
The problem is that Excel picks the first name that he finds, but I want him to look at the most recent/ active row of that name.

Thanks in advance for your help!

[humdingaling]

how is your query setup?
i cant tell where the formula goes and what its meant to compare against?

i can only tell you want to find the last occurrence of "Peter" in this case??