Extract Data based on conditions on multiple columns

Hi,

I have attached sample report in which i need to extract the data to sheet2 based on a particular preference.

Extract the complete row information of the table if item is A with latest date or B with the latest date or C with latest date or D with latest date or E with latest date.

Your help is highly appreciated

Hi,

Corrected the master report and also provided the required report in the sheet2. For each product code i need this check to be done with priority from A to E on the latest date information and accordingly the data should go to sheet2. Hope this explanation helps you. If you need further inputs please do let me know.

Thanks in advance

Hi Marcol,

Thank you for the help!

But there is a small change, the item name should also be picked up by the formula. In the sheet2 I will have only the product codes remaining things should be picked up by the formula following the preferential order.

Also is it possible to get this solution in both ways using formulae and macro coding as well. Because my team is not so go at formulae, if it is through a custom function it will be of great help..

Looking forward for your response..

Thanks

Hi Marcol,

I am sorry let me put it in writing the way I want it. Take the product code for example 1 this code might have come with many items A to Z with its respective dates and quantity. What I really want is, for the product code 1 it has to first search whether it has the item A if not B if not C it goes until Z. Preference of search is from A to Z. Then once it finds item let's say it has found A then we do not require the remaining data pertaining to code 1. Now it has to look at the dates of the item A pertaining to code 1, check which is the latest date for that item and for that particular code. Because for the same product code item A could have been coming twice with different dates, out of these i have to pick the latest one. Like I have to do it for the remaining codes until 5.

Hope this helps you..