How to merge these two formulas into single fomula-CodePudding

Home > database > How to merge these two formulas into single fomula

How to merge these two formulas into single fomula

Time：12-20

How to merge these two formulas into the single formula. I have tried but its not working.

Your help will be much appreciated.

=ArrayFormula(UNIQUE(trim(Sheet1!A1:E)))
=ArrayFormula(UNIQUE(trim(Sheet2!A2:E)))

What i have tried is:

=ArrayFormula(UNIQUE(trim(Sheet1!A1:E);trim(Sheet2!A2:E)))

and it throws an error

CodePudding user response：

a bit unclear of the scope but could you try:

=ArrayFormula(UNIQUE(trim({Sheet1!A1:E;Sheet2!A2:E})))