Calculating Last Vote

Hello!

I need some help with the sample file. I'm trying to calculate the most recent vote that 1 of 4 people made, and apply a set status. I've include the below conditions in the sample file and what I think the output should look like (Sample_Conditions tab). The Votes and Voter List tabs will be what is in the weekly workbook. Any help would be appreciated.

Conditions:
All four people on the Voter List tab, must vote prior to the Deadline indicated.
They each can vote multiple times on one order number, but we are only concerned with the last vote.
Voters may not vote at all.
There is a varying number of rows week to week, depending on how many order numbers there are for the week.

Trim list down to last vote for each person that is listed on the Voter List tab.

If last vote equals "Approve" or "Defer" and is before the deadline then Status equals "Met"
If last vote equals "Approve" or "Defer" and is after the deadline, then Status equals "Missed"

If the a person in the Voter List doesn't have a row associated with an Order number, they didn't vote.
If this condition is met, add a row with the Order Number and the Voter Name. Date/Time is blank and Status equals "No Vote"

Thank you in advance for any assistance.

try this by running the macro

Looks like both of these solutions work great! Thank you both...I know this was a tricky one!

you´re welcome, it was a quite a challange but happy to know that it help you out!!!