View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Frederik Frederik is offline
external usenet poster
 
Posts: 1
Default 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