There's a sample file here that may help you:

http://www.contextures.com/excelfiles.html

Under Filters, look for 'FL0019 - Filter Latest Date for Customer'

It uses an advanced filter to extract the latest Sale record for the
selected customer. In the criteria range, the formula for MaxDate checks
each record for the latest date.

Balan wrote:
Hi ! I have a table of several rows and columns. I want to extract the
values of select rows fully. The rows I want to select based on 3 different
criteria. For example, the array is a4:m50. Column A has dates.Column B has
names of the customers. Column C lists whether the transaction is "Purchase"
or "Sale". Column D has the unit value. I want to extract the entire row
values for "Sale" transactions by say customer X in column B on one of the
latest dates i.e, if the customer has sold material on more than one day, I
want the data relating to latest date. Through a formula I want to extract
data in respect of more than one customer. Is this possible ? Can any one of
you help ?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html