Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLookup in to columns
Hi,
Im trying to make a calendar from a list of dates with corresponding times (shown in the bottom of this message). My problem is how to make excel lookup a date and the corresponding time, when there are more times on the same date (Ie. on th 26-10-06, I want it to say 11:00, and in the cell below 12:15). 24-10-06 10:00 25-10-06 10:15 26-10-06 11:00 26-10-06 12:15 26-10-06 13:30 27-10-06 9:00 Hope some of you can help me. Best regards Frederik |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLookup in to columns
Try using the AutoFilter
"Frederik" wrote: Hi, Im trying to make a calendar from a list of dates with corresponding times (shown in the bottom of this message). My problem is how to make excel lookup a date and the corresponding time, when there are more times on the same date (Ie. on th 26-10-06, I want it to say 11:00, and in the cell below 12:15). 24-10-06 10:00 25-10-06 10:15 26-10-06 11:00 26-10-06 12:15 26-10-06 13:30 27-10-06 9:00 Hope some of you can help me. Best regards Frederik |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLookup in to columns
If you prefered the formula method then try this:
=IF(ISERR(SMALL(IF($A$1:$A$6=--"10/26/2006",ROW(INDIRECT("1:"&ROWS($B$1:$B$6)))),ROWS($1 :1))),"",INDEX($B$1:$B$6,SMALL(IF($A$1:$A$6=--"10/26/2006",ROW(INDIRECT("1:"&ROWS($B$1:$B$6)))),ROWS($1 :1)))) ctrlshiftenter (not just enter) Copy down as far as needed Format cells as hh:mm "Frederik" wrote: Hi, Im trying to make a calendar from a list of dates with corresponding times (shown in the bottom of this message). My problem is how to make excel lookup a date and the corresponding time, when there are more times on the same date (Ie. on th 26-10-06, I want it to say 11:00, and in the cell below 12:15). 24-10-06 10:00 25-10-06 10:15 26-10-06 11:00 26-10-06 12:15 26-10-06 13:30 27-10-06 9:00 Hope some of you can help me. Best regards Frederik |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Text to Columns" for many columns in Excel 2003 | Excel Discussion (Misc queries) | |||
2 way Vlookup - Creating array arguments from columns | Excel Discussion (Misc queries) | |||
Trying to do Vlookup on multiple columns from different worksheet | Excel Worksheet Functions | |||
Vlookup using two columns | Excel Worksheet Functions | |||
vlookup for multiple columns | Excel Worksheet Functions |