Concatenate function not working as expected

[katiedee1625]

My workbook has two worksheets - "Voucher" and "Totals". I need to copy the text (names of counties) in a range of cells K5:K123 on "Voucher" over to a single cell B6 on "Totals". However, I only need the names of the counties that meet a specific date range criteria on the Voucher worksheet that are in three date columns, S5:S123, V5:V123, Y5:Y123. Also, some counties will be duplicated in the results and I don't want the duplicates, but do want the results separated by commas. I've searched endlessly for formulas or VB codes, but have not come up with anything that meets the criteria where I don't have to redo the concatenate each time. I need this to be an automatic function. I've written code and formulas for all the other areas in the workbook, but have to say I'm stumped. Help with starting over in a better direction is much appreciated.

[pjwhitfield]

Can you attach a sample workbook? Its easier to understand when you can actually see the sheet.

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[katiedee1625]

I'll attach a sample workbook shortly. Thank you for your help!

[katiedee1625]

Attached is a sample workbook. Thank you for your help.

[JeteMc]

This proposed solution employs four helper columns that are added to the Vouchers sheet.
The array entered formula* that populates columns E:F is:

Please Login or Register  to view this content.

The formula that populates the columns G:H is: =IF(AND(ROW()=3,E4<>""),E3&", ",IF(E4<>"",G2&E3&", ",G2&E3))
On the Totals Before sheet the blue cells are linked to the last formula populated cell in columns G and H respectively.
*Array entered formulas are confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
Let us know if you have any questions.

[katiedee1625]

Thank you so much for your help, this solved the problem and works beautifully!

[JeteMc]

You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.