Filter on Listbox with only unique items

[hpernaf]

Hi everyone! Hope everyone is great!

Have a database with birthdays. Some records are repeated, as they are records of birthday parties over the years.

1.PNG

In a listbox, I need to get the birthdays from this database filtered by month. In other words, I need to select a month in Combobox and when searching, my Listbox should show only the birthdays of the selected month, but no duplicates.

2.PNG

For example, if I search for birthdays in the month of December, I need the Listbox to show only 1 record (Willian in this case)

I tried a few options, but I've never really done this type of filter with Listbox.
Would anyone know if this is possible?
Attached is my spreadsheet. Thanks in advance to anyone who can help me.

[torachan]

Give the attached solution a try.
It constructs a second table from the visible rows of the first table onto a hidden sheet.
Then the duplicates are removed from the second table and this is used to load the listbox list.
An array could possibly be used instead of the second sheet.
Any queries post back on this site.
torachan.

[hpernaf]

Thank you for your help! This was exactly what I needed.

[torachan]

Thanks for the feedback.
Glad to have helped.