look up sequential cells

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

stine_white - 30 Oct 2006 22:43 GMT

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

Reply to this Message

Otto Moehrbach - 31 Oct 2006 02:01 GMT

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

>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
[quoted text clipped - 8 lines]
> 10/26/06 5:00 data1 data2 data3
> 10/26/06 7:00 data1 data2 data3

Reply to this Message