Simple Filter

[tqm1]

Dear Sir,

I need help about simple filter.

Please review attachment

[mdmackillop]

Hi TQM,
This has the look of a homework assignment (http://www.vbaexpress.com/forum/faq.php?faq=psting_faq_item#faq_hom_faq_item).

[Simon Lloyd]

TQM, i will give you a push in the right direction!
in your DATA sheet insert a column at column A entitle it Count then in A2 paste: =IF(COUNTIF(B$1:B2,B2)=1,MAX(A$1:A1)+1,"") and copy down. In column C Give it a title Unique Names and paste this at C2 and copy down:
=IF(MAX(MyCount)<ROW(1:1),"",VLOOKUP(ROW(1:1),MyDateList,2))

you will find that #NAME? appears i will leave you to work out why that is happening (you need to research MAX and VLOOKUP functions).

FYI we are members of many forums and will not help further with questions regarding this, there is very little for you to accomplish now in this task and with some time and effort researching the things you need you will succeed!