Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
requires that merged cells must be identically sized? | Excel Discussion (Misc queries) | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
Sequential dates in different cells | Excel Worksheet Functions | |||
Sequential dates in different cells | Excel Worksheet Functions |