Thursday, September 4, 2014

Formula In Cell D1 For Cells Of Column D For Most Recent Unique Entry In Column B

                      Google Spreadsheet   Post  #1752
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Sep-04-2014
post by Jimmy DeBlasio:
(https://productforums.google.com/forum/#!mydiscussions/docs/Y0RwaWuY5Xc)
filter or index to show a list unique products and their most recent quantity
I have three columns. A lists the date of entry. B lists the unit #, C lists the updated qty for that unit. 

Sample data:  
           DateCol A                Col B
2/2/20145C4G31203D600
1/1/2014PJ110611D1600
3/1/2014PS121445Z1000
4/1/2014PJ110611D1200


In column D and E I want to use a filter or an index the all the units and their most recent quantity. 
5C4G31203D600
PS121445Z1000
PJ110611D1200
----------------------------------------------------------------------------------------------------------