Oldest dates first

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am finding the following senario odd in that it seems so simple but it just dosen't work for me..
The senario is, in sheet one I have "product" "Price" "sale date
eg 1 $10 oct 9 0
1 $5 nov 12 0
1 $30 nov 16 0
10 $30 oct 5 0
10 $5 nov 5 0
10 $30 nov 8 0
100 $7 oct 5 9
100 $5 nov 12 0
100 $30 nov 19 0
***I named products 1,10,100 because it was easierfor me to articulate**

In sheet two I want to be able to have a funtion pick out any given date from sheet one and have it display accross the top of the sheet two with the OLDEST DATE first and the product respectively below it, Price is not include
Like this

"sale date" oct 5 99 oct 9 00 oct 5 01 nov 12 01 nov 5 02 nov 12 02 nov 8 03 nov 16 03 nov 19 0

"product" 100 1 10 100 10 1 1 10 100

I have too many products to simply enter them one at a time
I have tried an if(vlookup(),mina(),"") senario but it seems to get garbled by the same product names being the same and the fact that I want the oldest date first..
any help is appreciate
Thanks for taking the time to review and respon
Luke
 
You would have a problem since I don't think your date would be
recognized as such, if they are I would use

=SMALL(Sheet1!$C$2:$C$10,COLUMN(A:A))

copy across until you get an error, then paste special as values and format
as dates
then in the next row use

=INDEX(Sheet1!$A$2:$A$10,MATCH(A1,Sheet1!$C$2:$C$10,0))

copy across

as I said it won't work until you have a numeric date value in the date
column


--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

Luke said:
I am finding the following senario odd in that it seems so simple but it just dosen't work for me...
The senario is, in sheet one I have "product" "Price" "sale date"
eg 1 $10 oct 9 00
1 $5 nov 12 02
1 $30 nov 16 03
10 $30 oct 5 01
10 $5 nov 5 02
10 $30 nov 8 03
100 $7 oct 5 99
100 $5 nov 12 01
100 $30 nov 19 03
***I named products 1,10,100 because it was easierfor me to articulate***

In sheet two I want to be able to have a funtion pick out any given date
Click to expand...
from sheet one and have it display accross the top of the sheet two with the
OLDEST DATE first and the product respectively below it, Price is not
included
Like this:

"sale date" oct 5 99 oct 9 00 oct 5 01 nov 12 01 nov 5
Click to expand...
02 nov 12 02 nov 8 03 nov 16 03 nov 19 03
"product" 100 1 10 100
Click to expand...
10 1 1 10 100
I have too many products to simply enter them one at a time.
I have tried an if(vlookup(),mina(),"") senario but it seems to get
Click to expand...
garbled by the same product names being the same and the fact that I want
the oldest date first...
 
Back
Top