View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
stine_white stine_white is offline
external usenet poster
 
Posts: 2
Default 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