Need help to add a condition to a concatenate formula

[dfm1plus6]

I'm using the following formula to combine date and time data from multiple cells:
=CONCAT(IF('JIRA Deploy Import'!H5<>"",CONCAT("G0 - ",TEXT('JIRA Deploy Import'!H5,"dddd"),", ",TEXT('JIRA Deploy Import'!H5,"mmmm dd,yyyy"),", ",TEXT('JIRA Deploy Import'!H5,"H:MM AM/PM"),",",TEXT(('JIRA Deploy Import'!I5-'JIRA Deploy Import'!H5),"H:MM")," hours & minutes"),""),"

",IF(('JIRA Deploy Import'!J5<>""),CONCAT("G1 - ",TEXT('JIRA Deploy Import'!J5,"dddd"),", ",TEXT('JIRA Deploy Import'!J5,"mmmm dd,yyyy"),", ",TEXT('JIRA Deploy Import'!J5,"H:MM AM/PM"),",",TEXT(('JIRA Deploy Import'!K5-'JIRA Deploy Import'!J5),"H:MM")," hours & minutes"),""),"

",IF('JIRA Deploy Import'!M5<>"",CONCAT("G2 - ",TEXT('JIRA Deploy Import'!M5,"dddd"),", ",TEXT('JIRA Deploy Import'!M5,"mmmm dd,yyyy"),", ",TEXT('JIRA Deploy Import'!M5,"H:MM AM/PM"),",",TEXT(('JIRA Deploy Import'!M5-'JIRA Deploy Import'!L5),"H:MM")," hours & minutes"),""))

The characters G0, G1, and G2 represent regions where events are scheduled. It's working fine for concatenating the date to a single cell in a new sheet. However, sometimes we have the same date and time for events in different regions. Right now the formula just returns up to three different lines in the same cell. I'd like to be able to add a condition for the formula that identifies if the date and time are the same, and then just combine the G0 thru G2 characters if appropriate.

Any suggestions?

[TFiske]

Could you please attach a sample of your workbook? Please obscure/substitite sensitive data. Include enough data to be representative of your whole data set. Also include expected values.

To do this click on:

Reply>Go Advanced>Manage Attachments>Choose File>Upload>Close window>Submit Reply

Youre situation is a little complicated. We feed on data.