View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Huggy Huggy is offline
external usenet poster
 
Posts: 14
Default Look up last and next entry

I have a spreadsheet with column A being list of dates (from 1/1/08 - 31/12/10)
in order and column B a list of codes. Each codes periodically is repeasted
in no fixed order. Column C and D have data that relate to the code in column
B.