<div>
Hi,<br />
<br />
Could you send a dummy?<br />
<br />
Regards
</div>


<div>
you could use for all unique values non empty<br />
<br />
&lt;&gt;&quot;&quot;<br />
<br />
or as alternative you could use Data / Data Tools / Remove Duplicates
</div>


<div>
Based on what you say, in order to have criteria for a specific table, add a couple of rows above your table to make the criteria range. &nbsp;Note that if you want an AND or OR be sure to have the values on separate rows (for an OR) and repeat criteria for AND in all rows<br />
Check the example I've attached. &nbsp;Hope this helps!<br />
<br />
Good explanation here<br />
<a href="https://support.microsoft.com/en-us/kb/2720580" rel="ugc">https://support.microsoft.com/en-us/kb/2720580</a><br />
<br />
LMK if you want to work on a sample of your own<br />
<a href="https://filedb.experts-exchange.com/incoming/2016/08_w32/1110269/AdvFilterExample.xlsx" target="_blank" class="file-inline" title="Adv Filter example (11 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>AdvFilterExample.xlsx</a>
</div>


AdvFilterExample.xlsx

<div>
Hi. &nbsp;I thought I would provide some more information.<br />
Firstly, I am wishing to filter my table so it can be used as lookup table<br />
Secondly, I have attached an example of the original table and what I wish it to be after filtering so only unique values in column D.<br />
<br />
If an answer already given is still relevant, let me know. (as it wasnt clear to me)<br />
Or if a new answer is more suited, also let me know.<br />
<br />
Thanks<br />
<a href="https://filedb.experts-exchange.com/incoming/2016/08_w33/1110459/Lookup-table.xlsx" target="_blank" class="file-inline" title="example of the original table and what I wish it to be after filtering so only unique values in column D (9 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>Lookup-table.xlsx</a>
</div>


example of the original table and what I wish it to be after filtering so only unique values in column D

Lookup-table.xlsx

<div>
Hi,<br />
<br />
pls try<br />
<br />
my example &nbsp;added column for first unique Col D value and formulas for lookup<br />
<br />
Regards<br />
<a href="https://filedb.experts-exchange.com/incoming/2016/08_w33/1110513/Lookup-tableV1.xlsx" target="_blank" class="file-inline" title="EE (10 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>Lookup-tableV1.xlsx</a>
</div>


Lookup-tableV1.xlsx

<div>
Thanks Rgonzo<br />
I noticed your formula in Column F relied on comparing a cell in Column D with the one above it.<br />
So if the cell value was the same as a cell more than 1 cell above it, &nbsp;it said it was unique, which is not true.
</div>


<div>
Hi. &nbsp;Andy's suggestion to remove duplicates worked for me on the example I uploaded.<br />
Thanks for everyone suggestions.
</div>


<div>
then use as formula<br />
<br />
=IF(COUNTIF($D$4:D4,4)&gt;1,F<wbr />ALSE,TRUE)<wbr />
</div>


<div>
Thanks Andy<br />
The suggestion to remove duplicates worked well. &nbsp;I didnt realise at first it would remove rows belonging to duplicates. Thats why I took awhile to award.
</div>


<div>
I suggested as well to remove duplicates<br />
<a href="https://www.experts-exchange.com/questions/28961687/Excel-Table-Filtering-on-Unique-Values-in-specific-column.html?anchor=a41746686&anchorAnswerId=41743734#a41743734" rel="ugc">https://www.experts-exchange.com/questions/28961687/Excel-Table-Filtering-on-Unique-Values-in-specific-column.html?anchor=a41746686&anchorAnswerId=41743734#a41743734</a>
</div>


<div>
Sorry Rgonzo<br />
as it was it was in your 2nd alternative I missed the significant of it.<br />
Then when I went back to review answers saw it as Andy's first suggestion.
</div>


<div>
<div class="content wysiwyg-content">
Hi<br />
I have a table with 5 columns (A to E).<br />
I wish to filter based on criteria of unique values in Column D (which is by the way a concatenation of Columns A &amp;&nbsp;B)<br />
Im trying to use Advanced Filter with little success.<br />
I assume the List range is the whole table, and I select the box unique records only. &nbsp;But what do I put in criteria range?<br />
Or should I be doing it differently?
</div>
</div>


Hi
I have a table with 5 columns (A to E).
I wish to filter based on criteria of unique values in Column D (which is by the way a concatenation of Columns A & B)
Im trying to use Advanced Filter with little success.
I assume the List range is the whole table, and I select the box unique records only.  But what do I put in criteria range?
Or should I be doing it differently?

Excel Table - Filtering on Unique Values in specific column

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.