Good morning
I am looking to find the newest ship date based on the vendor and the item. We have the same item shipped by different vendors, but I am looking for the individual item from each vendor. I have included a sample sheet. I can do it with one variable I believe, but I think it involves index and matching.
Any help would be appreciated.
Thanks
Brent
Maybe something like this
Formula in in H2 copied down
Corrected:
Formula:
Please Login or Register to view this content.
v A B C D E F G H 1 Vendor Item Date of Shipment Vendor Item Max of Date of Shipment 2 a x 10-Jan a x 1/12/2016 3 a x 11-Jan a y 1/10/2016 4 a x 12-Jan a z 1/10/2016 5 a y 10-Jan b x 1/10/2016 6 a z 10-Jan b y 1/12/2016 7 b x 10-Jan b z 1/10/2016 8 b y 11-Jan c x 1/10/2016 9 b y 12-Jan c y 1/11/2016 10 b y 10-Jan c z 1/12/2016 11 b z 10-Jan 12 c x 10-Jan 13 c y 11-Jan 14 c z 12-Jan 15 c z 11-Jan 16 c z 10-Jan
Last edited by AlKey; 01-26-2016 at 01:04 PM. Reason: Added excel file with formula and PivotTable solutions
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
This will work if I can reduce the list down, but My file has roughly 50,000 lines with 100+ vendors and 1,000's of items. If I can use that code in column D, it would be much easier.
You can use the same formula in Col D just change F2 to A2 and G2 to B2 and adjust ranges accordingly to your needs. But since you have duplicates so will be the results.
This worked. I just copied the data over and removed duplicates. Thank you very much for the help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks