CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formula
HSHO
HSHO

Reputation: 525

How to merge these two formulas into single fomula

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

Upvotes: 0

Views: 31

Answers (1)

rockinfreakshow
rockinfreakshow

Reputation: 29967

a bit unclear of the scope but could you try:

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

Upvotes: 1

Related Questions