Need Distinct List Returned

Hi All,

I am looking for a formula that will continually pull distinct values from a list based on the date information in an adjacent column.

If the date in column C matches the date range in column A, I want all distinct values for column B to be listed in separate columns (W, X, Y...) based on their date.

DistinctList.jpg


DistinctList1.jpg


I have already tried using Advanced Filter, but it won't continue to update as more information is inserted into the sheet.

Please let me know if there are any questions.

Your help is greatly appreciated!

Thank you!