Concatenate help from one worksheet to another

[katiedee]

I can't find a way, without creating a very long process, to concatenate text from a column A (counties) on Sheet1, based on conditions (date range in column B), to a single cell (A1) on Sheet2. The final value must not have duplicates either and text will need to be separated by commas.

This is the last formula/code I need before wrapping up the project. Any help is appreciated.

I have a sample workbook, but don't have permission to post, assuming it's because I am an infrequent visitor to this site.

Thanks in advance!

 

[hiker95]

I have a sample workbook, but don't have permission to post

katiedee,

You can post your workbook/worksheets to the following free site (sensitive data changed), mark the workbook for sharing, and, provide us with a link to your workbook:

https://dropbox.com