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

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

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