Can't resolve Formula Error: Array argument to IF are of different size

Ask for Help
1

I’m sure there is a simple solution to this one, but for some reason I can’t seem to work out the issue.

I’m simply copying all unique values from the App: Logins sheet where there are obviously duplicates (multiple logins) and obviously the list size is different.

How can I get rid of the error?

image

2

If all you want is the UNIQUE emails then you don’t need the ARRAYFORMULA.
=UNIQUE(‘App: Logins’!B2:B) . that is it.

3

Thanks George, that got rid of the error