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
----------------------------------------------------------------------------------------------------------
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:
Date | Col A | Col B |
2/2/2014 | 5C4G31203D | 600 |
1/1/2014 | PJ110611D1 | 600 |
3/1/2014 | PS121445Z | 1000 |
4/1/2014 | PJ110611D1 | 200 |
In column D and E I want to use a filter or an index the all the units and their most recent quantity.
5C4G31203D | 600 |
PS121445Z | 1000 |
PJ110611D1 | 200 |
No comments:
Post a Comment