Concatenate with if conditions

[PAOLO7673]

Hi everybody.
I need some help in getting the code to do the follow:
1 CONDITION : if CODE A is repeated
2 CONDITION : if STATUS E is ok
then : concatenate invoices & REF
but : skipp all double REF.

IF THE STRING IS SHOWN ON EACH LAST CODE ONLY WOULD BE PERFECT!!
Many thanks in advance for your help.
paolo

 

[Sektor]

Could you upload your workbook to some cloud storage?

 

[PAOLO7673]

Could you upload your workbook to some cloud storage?

Here is the link.
Thank you!

Dropbox

www.dropbox.com