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.
Bookmarks