I'm using the following formula to get the unique values of Column J from another sheet (named "Data") and listing those unique values in Column G on the current sheet.
=IFERROR(INDEX(Data!$J$2:$J$71,MATCH(0,COUNTIF($G$21:G21,Data!$J$2:$J$71),0)),NA())
Its working fine as is, but i would like to make a few tweaks and cant get it figured out.
I'd like to:
1. Only lost the unique values that show when the table is filtered.
2. If possible, not have to set a Column G range in order to avoid blank (N/A, or just just unnecessary) rows in the new table.
Thanks
Bookmarks