Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |