Array calculation problem

[TomParkD]

I am preparing a cashflow from a transaction page using named ranges and arrays. I have a number of supplier names that look identical but information from different sections of the transactions page shows on 2 lines in the cashflow page when you would only expect 1. I try to remove duplicates in the cashflow page when clearly there are duplicates but Excel tells me there are none. I can copy and paste the supplier name from the transactions page and paste it in the cashflow page and it will work. The problem seems to come from formatting but I cant understand why.

The names in the cashflow page look the same and the formulas are the same but I cant show the entries together in a single line The columns are week numbers. The supplier name comes from 2 sections of the transaction page and look identical

Lanz Group - - - 84 - - - -
Lanz Group - - - - - - - 498

The array
{=SUM(((CashflowName=$C102)+(Weeknumber=('Trial balance'!AY$11))=2)*GrossAmount*(CalendarYear=YEAR(H$6)))}

 

[JoeMo]

Not sure I understand your issue correctly, but have you compared the two nominally identical names to see if they are identical? For example, suppose A1 on the cashflow page looks like Lanz Group and B1 seems to contain the same value, then:
In C1 enter =EXACT(A1,B1)

if this does not return TRUE then in D1 enter =LEN(A1)-LEN(B1)

if this does not return 0 then one of the cells has one or more extra spaces or other non-apparent character(s).

To test for extra spaces see if =EXACT(TRIM(A1),TRIM(B1)) returns TRUE.