hi all,
please help
A1:A100 is for the date values (for each entry a single date)
B1:B100 is holding names (text values) which might be repeated in many
entries
C1 is a referece cell, where i may put any name (from the list B1:B100)
where i want to retrieve the adjacent date of the last occurrence of that
particular name which i put in C1
many thanks for any help