T
Tom
I have a spreadsheet with multiple dates for multiple products and
prices in addition to other data in several colums. I would like to
pick the latest ie. most recent price for each product and also display
the additional data ie. all the data in the row.
01/01/2003 30000051 3.52 2,561 10,054
01/24/2004 30000051 3.65 3,465 5,678
04/07/2005 30000051 3.45 5,675 3,442
04/06/2004 30000077 4.55 6,994 3,997
05/22/2004 30000077 6.73 9,956 3,455
06/09/2005 30000077 9.56 5,812 4,778
08/08/2005 30000077 8.99 6,982 3,337
etc.
the end result should be the following data being displayed:
04/07/2005 30000051 3.45 5,675 3,442
08/08/2005 30000077 8.99 6,982 3,337
Thanks
prices in addition to other data in several colums. I would like to
pick the latest ie. most recent price for each product and also display
the additional data ie. all the data in the row.
01/01/2003 30000051 3.52 2,561 10,054
01/24/2004 30000051 3.65 3,465 5,678
04/07/2005 30000051 3.45 5,675 3,442
04/06/2004 30000077 4.55 6,994 3,997
05/22/2004 30000077 6.73 9,956 3,455
06/09/2005 30000077 9.56 5,812 4,778
08/08/2005 30000077 8.99 6,982 3,337
etc.
the end result should be the following data being displayed:
04/07/2005 30000051 3.45 5,675 3,442
08/08/2005 30000077 8.99 6,982 3,337
Thanks