I am totally confused on the goal
If I filter for FACIL in the recipient name and then lis by worker by day I get something like this - is this what you expected to see?
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Thank you very much for your very quick answer.
Sorry if I was a bit confusing in the explanation of my goal. I will try to keep it shorter.
Basically, I have this structure:
Recipients Names Worker Name Arrival Time ABC Facil A 01/11/2016 13:11:58
Stephanie A 01/11/2016 17:11:58
Steven A 03/11/2016 14:11:58
XYZ Facil A 03/11/2016 17:11:58
Julio A 05/11/2016 10:11:58
TUV Facil A 05/11/2016 19:11:58
Franck A 01/11/2016 18:11:58
Out of this, I would like to be able to have only the lines in which the "Facil" Recipients Names do not appear originally, but next to them I would like to have the only "Facil" Recipients Names they have for that worker in that day (because there is always just one or at most two of these "facil" names). So in the example above I would obtain something like this ideally:
Recipients Names Worker Name Arrival Time New Recipients Names Column Stephanie A 01/11/2016 17:11:58
ABC Facil Steven A 03/11/2016 14:11:58
XYZ Facil Julio A 05/11/2016 10:11:58
TUV Facil Franck A 01/11/2016 18:11:58
This would exclude the lines that had the "Facil" in the Recipients Names in the original column basically.
Hope my explanation was clearer now and thank you once again for your help.
Sorry to bother again on this.
I was wondering if you had had time to look at this in these weeks.
I have not - there is not a relationship between the first and follow records in your data - don't know of a way to get what you want
Thank you for your answer.
I am aware there is no clear relationship, but I was wondering if there was a workaround in terms of formulas to make the new field understand that I want to pick up a value from "Recipients Names" when this has "facil" inside it for every Day (possibly the last Recipients Names with "facil" appearing in that day) and for every Worker appearing in the list.
Thanks a lot once again for your help and for your opinion on this.
This is definitely super helpful. However, I am realizing it is not working properly in the below case.
Ripan Rudra should give "Facility-JUB" for the 2nd of November, while "HT-Facility" is showing up in your worksheet. I think the MAX function is probably not taking into account the date when coming to give the last value with "facil"?
Thank you very much for your help!