Good afternoon
Is it possible to rank as per below as I am trying to record how many times something has been done by a person on a daily basis.
I am trying to rank the data so I can use the first instance of the day later in another formula.
ie, if Rank is 1 vlookup another table and pull information in.
"Due Date" is in format "dd/mm/yyyy hh:mm" as per custom and "Assigned to" is text
Hopefully this is a simple question, but I have been going round in circles this afternoon
thanks in advance
Gavin
Is it possible to rank as per below as I am trying to record how many times something has been done by a person on a daily basis.
I am trying to rank the data so I can use the first instance of the day later in another formula.
ie, if Rank is 1 vlookup another table and pull information in.
"Due Date" is in format "dd/mm/yyyy hh:mm" as per custom and "Assigned to" is text
Hopefully this is a simple question, but I have been going round in circles this afternoon
thanks in advance
Gavin