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 ?