conditional sorting of data
I tried to sort data using autofilter and advanced filter. Both were not
helpful. My data has the following columns: Date Name Transaction Qty The transaction could be "Purchase" or "Sale". Under same names different types of transactions could be there on different dates. I want the "Qty" data for the latest date in respect of "Purchase" made by each per son ( "names"). The latest date is different for different names. However. When I used advanced filter I am not able to get the required data. In the criteria range for advanced filter under the Date column I used =Max() function to filter the latest date for each name. But I am getting the latest date for the entire range put together (i.e., the max date of all entries in Date column), instead of the max date for each name under "Purchase". I tried Index and Match functions also; But I am not able to frame the formula to suit my requirement using these two functions. Can anyone help ? Thanks in advance |
All times are GMT +1. The time now is 12:48 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com