I have a google sheet that records shipment dates to various locations. Each location is identified with a code (i.e., VN934). Many of these locations have multiple shipments. I need to pull out the rows of each code with the most recent shipment date.
For example, the sheet may have:
VN934 3/8/2016
VN934 7/5/2017
VN935 6/7/2016
In this example, I need row2 (most recent date) and row3 to be copied to another sheet.
The destination sheet will then be a list of all unique codes + the rest of the data from the corresponding cells in each copied row.
I can be done thru macro, i have 2 excel experts will support you, let me know when you want
Relevant Skills and Experience
VB
Proposed Milestones
$41.5 USD - VB 1
$41.5 USD - VB2
Let me know when you want, imm support not possible
With respect to this project I would like to present myself as a candidate for your consideration. I have more than 8 years of IT experience. I have successfully completed few projects for US clients
Relevant Skills and Experience
VB
Ms-Excel
Proposed Milestones
$77 USD - This task will be completed within schedule
Dear Sir or Ms.
I am John, pleased to meet you.
All your requirements are achievable.
Relevant Skills and Experience
I'm well experienced in Google Apps Script and G Suite.
Please, take a look at my portfolio in my profile.
Thank you for your time !
John
Proposed Milestones
$40 USD - Final delivarable