Hi there,

I hope you are well!

I am trying to find a formula that makes a cell say "Account Active" if any of the accounts are active in a table.

I have attached a spreadsheet with further information in. Please feel free to have a look and give it a go!

Thanks

Mike

Active Account.xlsx