UNIQUE function does not filter values

Question

=arrayformula(UNIQUE(
{
IFERROR(FILTER('New Bets'!A3:H,'New Bets'!I3:I<>""),{"","","","","","","",""})
;
IFERROR(FILTER(Alertas!A2:H101,Alertas!I2:I101<>""),{"","","","","","","",""})
}))

=UNIQUE(A3:H)

When I use Unique separately from the rest of the formula, it correctly returns only one row with data, without duplicates. But when using inside the formula, it returns two equal values.

I wonder what I'm doing wrong.

Link to Spreadsheet:
https://docs.google.com/spreadsheets/d/1sv1B1mYrhpzS-ZtCLfLkVPtbffWq231woEX_qOxiAXA/edit?usp=sharing

@player0 I had forgotten, done!

Digital Farmer
– Digital Farmer

2019-12-13 18:53:37 +00:00
Commented Dec 13, 2019 at 18:53 — Digital Farmer
– Digital Farmer, Commented Dec 13, 2019 at 18:53

player0 · Accepted Answer · 2019-12-13 18:58:16Z

1

try:

=ARRAYFORMULA(UNIQUE(TRIM(
 {IFERROR(FILTER('New Bets'!A3:H,'New Bets'!I3:I<>""),{"","","","","","","",""});
  IFERROR(FILTER(Alertas!A2:H101,Alertas!I2:I101<>""),{"","","","","","","",""})})))

answered Dec 13, 2019 at 18:58

player0

131k14 gold badges91 silver badges149 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

UNIQUE function does not filter values

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related