VLookup in to columns

[Guest]

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

 

[Guest]

Try using the AutoFilter

 

[Guest]

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))))

ctrl>shift>enter (not just enter)
Copy down as far as needed
Format cells as hh:mm