Showing posts with label Cloud Computing post by Jimmy DeBlassio. Show all posts
Showing posts with label Cloud Computing post by Jimmy DeBlassio. Show all posts

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
----------------------------------------------------------------------------------------------------------