Excel Macro to find unique distinct value based on Criteria

You can filter the data then do whatever you want with , check out the attached example..

Change A2 to get the list for B2, then select B2 to get the filtered data.