Excel search

[Channa78]

I have a list with names of people who have been coming to me for consultancyin 2022. Every person comes more than once, so in the list a name can be like five times ( a visit on januari 2, february 5, etc). 

Now I would like to filter out the times one person has come to me and have the date behind it when they visited me. 

So then I have an automatically generated excel sheet with all the dates one person has visited me in 2022.

I don't have excel 365. Does anyone have tips how to realise this?

Thanks in advance,

Kind regards, Channa 

[#2]

@Channa78 

The best solution could be to discard the legacy version of Excel and get 365.  Then

= FILTER(table, nameList=name)

would work.  For older versions you could add record and field sequence numbers and use SMALL to compress the array of matching sequence numbers.

= IFERROR(INDEX(table,
      SMALL(IF(nameList=name,seq), seq),
      field),
  "")