View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pete@cadth Pete@cadth is offline
external usenet poster
 
Posts: 1
Default Concatenate with date range

Hi,

I have 3 columns and multiple rows.
Column A contains the product name
Column B contains the start date
Column C contains the completion date

I would like to concatenate all the product names within a specified date
range into 1 cell. I already have my date range identified in another tab
(i.e. FY!E3:E4)
Any ideas how I can do this?

Thanks.