Forum

Thanks very much Mynda, the closest I can get it to working is the below which basically works other than if there is no transactions for an account i...

If I do that it duplicates the terms where there is more than one term for that type, I wish to basically do a vlookup and return the first non blank ...

Hi Anders, Thanks for your response, that doesn't work the values for the terms are in text format i.e. 30 Days End of Month, 52 End of Month etc i...