look up sequential cells
 

I am trying to create a table that shows the previous 3 days worth of data
when the user inputs a date into a cell. There are multiple rows with the
same date but different times. What is the easiest way to do this?
(Example of the data sheet below.)

10/25/06 19:00 data1 data2 data3
10/25/06 21:00 data1 data2 data3
10/25/06 23:00 data1 data2 data3
10/26/06 1:00 data1 data2 data3
10/26/06 3:00 data1 data2 data3
10/26/06 5:00 data1 data2 data3
10/26/06 7:00 data1 data2 data3

look up sequential cells
 

Do you mean that you have a table somewhere that has the data for ALL the
dates, and when the user enters a date in some cell, you want a smaller
table created somewhere else that has only the last 3 days worth of data?
If so, do you want this smaller table in the same sheet as the larger table?
Please post back and clarify what you have and what you want. HTH Otto
"stine_white" wrote in message
...
I am trying to create a table that shows the previous 3 days worth of data
when the user inputs a date into a cell. There are multiple rows with the
same date but different times. What is the easiest way to do this?
(Example of the data sheet below.)

10/25/06 19:00 data1 data2 data3
10/25/06 21:00 data1 data2 data3
10/25/06 23:00 data1 data2 data3
10/26/06 1:00 data1 data2 data3
10/26/06 3:00 data1 data2 data3
10/26/06 5:00 data1 data2 data3
10/26/06 7:00 data1 data2 data3