Identifying all unique entries in a given column without array formula?

[virtuosok]

Hi,
I currently have an array formula to pull all unique entries into a separate column and it works like a charm
={(IFERROR(INDEX($E$7:$E$99999, MATCH(0,COUNTIF($O$6:O6, $E$7:$E$99999), 0)),""))}
Is there any other way to achieve this without array formula? I'm asking because of array formulas incompatibility issues with Google Docs.
Thanks.

[AliGW]

Try this:

=IFERROR(INDEX($E$7:$E$99999,MATCH(0,INDEX(COUNTIF($O$6:O6,$E$7:$E$99999),0,0),0)),"")

[PaulM100]

Or this:

=IFERROR(LOOKUP(2,1/(COUNTIF($O$6:O6,$E$7:$E$99999)=0),$E$7:$E$99999),"")

[johnmpl]

Hi, to all!

In Google Docs, you have the UNIQUE function. Just put, in one cell:
=UNIQUE(E7:E99999)

Blessings!

[virtuosok]

Wow so many solutions - thanks all! I tried the first one suggested and it fits my needs already. Let me try the others, too

[AliGW]

You're welcome!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.