Concatenate with date range
Best way is to write a Macro which will loop through the range and concatenate.
Concatenate has a limit of 255 cells. One way is to write a formula like the
following, copy it into the number of entries in your range, and concatenate
the formula into the result cell -
=IF(AND(IF(B1FY!$E$3,1,0),IF(C1<FY!$E$4,1,0)),A1, "")
"Pete@cadth" wrote:
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.
|