Hi Amanco

First sort visit_Number in descending order. Next go to advanced filter, click on Unique Records and then click ok. You will find below results:

Visitor_ID....Visit_Date...........Visit_number....Data
1................Aug 2/2013.........3....................Orange
2................July 15/2013........2....................Pink

Thanks
Shyam