How to extract duplicates with date as well.

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Hi rpclarke94 and welcome to the forum,

See the attached where I've added a Helper column with a Countifs() formula and then done an advanced filter to get the results I think you want. I created some random data to show what I think you have.

Countifs() and Adv Filter for Helper.xlsx

Using the sample file attached to post #4 try the following:
1. Convert A1:B9 into a table
2. Add a helper column (duplicates) populated using: =COUNTIFS([Name],[@Name])>1
3. Populate the Duplicates column of the output range using: =IFERROR(INDEX(Table1[Name],AGGREGATE(15,6,(ROW(Table1[Name])-ROW(Table1[[#Headers],[Name]]))/(Table1[duplicates]=TRUE),ROWS(A$1:A1))),"")
4. Populate the Dates column of the output range using: =IF(E2="","",AGGREGATE(15,6,Table1[Date]/(Table1[Name]=E2),COUNTIFS(E$2:E2,E2)))
Note that if another row is added to the table (by selecting cell B9 and pressing the tab key) then Sarah is given the date 12/9/19 her name and the new date will appear in the output range.
Note that, as shown, similar results may be obtained using a pivot table.
Let us know if you have any questions.

You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.