# How to filter Lookup options to omit duplicates **URL:** \ **Category:** Ask the Community\ **Created:** [October 2, 2020, 11:07pm UTC](https://connect.superhuman.com/t/how-to-filter-lookup-options-to-omit-duplicates/18706 "2020-10-02T23:07:33Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Connor\_McCormick](https://avatars.discourse-cdn.com/v4/letter/c/e79b87/32.png) [@Connor\_McCormick](https://connect.superhuman.com/u/Connor_McCormick)\ **Post date:** [October 2, 2020, 11:07pm UTC](https://connect.superhuman.com/t/how-to-filter-lookup-options-to-omit-duplicates/18706/1 "2020-10-02T23:07:33Z")
When I use a lookup from a table that has grouped items, I often only want to select one of the many duplicate names in that table. How do I filter the Lookup options so that only one unique option shows up. I have already tried `Item settings -> Filter`s like: `[Target Table].Unique()` `Name.Unique()` `[Target Table].Filter([Target Table].Name.Unique().FormulaMap(RowId(CurrentValue)).Contains(CurrentValue.Name.RowId()))` None of those work ![image](https://global.discourse-cdn.com/coda1/original/3X/1/1/115e2cd6bf87e62bcb19537c36c2437505b1332c.png) ---
**Author:** ![Ander](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/ander/32/9134_2.png) [@Ander](https://connect.superhuman.com/u/Ander)\ **Post date:** [October 2, 2020, 11:36pm UTC](https://connect.superhuman.com/t/how-to-filter-lookup-options-to-omit-duplicates/18706/2 "2020-10-02T23:36:40Z")
@Connor_McCormick Sounds like a schema problem, but without seeing a dummy doc, it’s tough to say. Here’s one possible approach: https://coda.io/embed/tkwEjibqFy/_sut2s?viewMode=embedplay ---
**Author:** ![Connor\_McCormick](https://avatars.discourse-cdn.com/v4/letter/c/e79b87/32.png) [@Connor\_McCormick](https://connect.superhuman.com/u/Connor_McCormick)\ **Post date:** [October 3, 2020, 12:10am UTC](https://connect.superhuman.com/t/how-to-filter-lookup-options-to-omit-duplicates/18706/3 "2020-10-03T00:10:02Z")
Clever! Thank you. Is there any way to do the same thing directly in a single item filter formula? ---
**Author:** ![Ander](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/ander/32/9134_2.png) [@Ander](https://connect.superhuman.com/u/Ander)\ **Post date:** [October 3, 2020, 12:32am UTC](https://connect.superhuman.com/t/how-to-filter-lookup-options-to-omit-duplicates/18706/4 "2020-10-03T00:32:03Z")
There’s probably a way. Whether it would be worth the overhead or not is another question.🕶 Tough to add much more without understanding a specific use case. ---
**Author:** ![Connor\_McCormick](https://avatars.discourse-cdn.com/v4/letter/c/e79b87/32.png) [@Connor\_McCormick](https://connect.superhuman.com/u/Connor_McCormick)\ **Post date:** [October 3, 2020, 12:39am UTC](https://connect.superhuman.com/t/how-to-filter-lookup-options-to-omit-duplicates/18706/5 "2020-10-03T00:39:03Z")
No problem, thank you for your help. The essential usecase is a way to build out packages containing multiple components. I want to be able to select the packages and then order all the internal components (without having to select the components individually). Does that make sense? ---
**Author:** ![Ander](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/ander/32/9134_2.png) [@Ander](https://connect.superhuman.com/u/Ander)\ **Post date:** [October 3, 2020, 12:42am UTC](https://connect.superhuman.com/t/how-to-filter-lookup-options-to-omit-duplicates/18706/6 "2020-10-03T00:42:11Z")
Sounds like a schema issue. If you want to mock up a dummy doc with the same structure, or share something offline, I’ll take a look for you. ---
**Author:** ![Connor\_McCormick](https://avatars.discourse-cdn.com/v4/letter/c/e79b87/32.png) [@Connor\_McCormick](https://connect.superhuman.com/u/Connor_McCormick)\ **Post date:** [October 3, 2020, 1:03am UTC](https://connect.superhuman.com/t/how-to-filter-lookup-options-to-omit-duplicates/18706/7 "2020-10-03T01:03:05Z")
Happy to share the real thing, it’s all dummy data anyway. I’ll private message it ---
**Author:** ![Connor\_McCormick](https://avatars.discourse-cdn.com/v4/letter/c/e79b87/32.png) [@Connor\_McCormick](https://connect.superhuman.com/u/Connor_McCormick)\ **Post date:** [October 3, 2020, 1:04am UTC](https://connect.superhuman.com/t/how-to-filter-lookup-options-to-omit-duplicates/18706/8 "2020-10-03T01:04:41Z")
Hmm, won’t let me message you privately. It says your public profile is hidden. What’s your coda email address? ---
**Author:** ![Connor\_McCormick](https://avatars.discourse-cdn.com/v4/letter/c/e79b87/32.png) [@Connor\_McCormick](https://connect.superhuman.com/u/Connor_McCormick)\ **Post date:** [October 3, 2020, 1:51am UTC](https://connect.superhuman.com/t/how-to-filter-lookup-options-to-omit-duplicates/18706/9 "2020-10-03T01:51:02Z")
@Ander, thank you so much for your help! For those wondering, the solution in this case was to normalize the data. @Ander Maybe you can make a quick How To post on what normalization is and how it works.