Hi,

I have a problem - I have a spreadsheet that shows a list of customers, together with their outstanding invoices. I have a formula to SUMIFS the balance of invoices based on the month they were due, but I therefore have ended up with multiple entries per customer if their debt is due from multiple months.

What I am looking to do is concatenate the month/balances together IF the customer name in column A is the same (ie multiple entries) - kind of like a sumif, but to join text not numbers.

My customer names are in column A,
My total outstanding debt is in column L (irrespective of month)
My month due & balance (text format) are in column N.

I want to end up with a report that display customer names only once, along with their total outstanding debt, and a display of months & balances due.

Please help!?!