View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Victor Delta[_2_] Victor Delta[_2_] is offline
external usenet poster
 
Posts: 199
Default Help with Array formula?

Can anyone help me with an appropriate array formula please - at least I
assume the following will need an array formula.

I have a spreadsheet which, in two adjacent columns (say A & B), records
names of people and dates of meetings with them. Many of the names are
repeated. NB Not all the dates are in chronological order.

In Col D I have a simple list of all the names (not repeated). What I would
like to show in the corresponding cells in Col E is the date of the most
recent meeting with each person on the list.

So far it's defeated me - can anyone help please?

Thanks,

V