Using VBA or Macros to get multiple results

[jarust91]

Hello,

I currently have a table with a couple thousand pieces of data. What I am trying to do is create a formula of some type to know all the corresponding dates to a certain person based on their status.

Name	Status	Last Modified
John Doe	Completed	16-Aug
Jane Doe	Scheduled	15-Aug
Jimmy Doe	Exited	14-Aug
John Doe	Completed	10-Aug
Jane Doe	Reg. Completed	4-Aug
Jimmy Doe	Registration	1-Aug
John Doe	Unreachable	31-Jul
Jane Doe	Completed	31-Jul
Jimmy Doe	Scheduled	29-Jul
John Doe	Reg. Completed	25-Jul
Jane Doe	Abandoned	25-Jul
Jimmy Doe	Exited	15-Jul
John Doe	Scheduled	15-Jul
Jane Doe	Completed	14-Jul
Jimmy Doe	Completed	14-Jul
John Doe	Scheduled	13-Jul
Jane Doe	Completed	13-Jul
Jimmy Doe	Scheduled	10-Jul

<colgroup><col><col><col></colgroup><tbody>
</tbody>

This is what the table looks like. I would want to know all the corresponding dates from John Doe when his status is completed. Ideally, I would be able to do this for all of the names.

Any help would be great appreciated.

Thanks,

Jarust91

 

[jarust91]

Sorry this was in reply to "C with no eyes"

 

[C with no eyes]

Yes, near the top find the section that relates to sorting c:c. Modify the order= from xlDescending to xlAscending.