![Kaley_White Kaley_White](https://community.airtable.com/legacyfs/online/avatars/3X/8/b/8b916c69e36fa9ab7f50bf04ea1dc772f35f9f50.jpeg)
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 29, 2023 11:45 AM
I need unique lookup values. This can only be done using a rollup field, which removes formatting. I need unique values but retained formatting.
Lookup field: Contains duplicates
Rollup field: No formatting
What I need: Lookup field w/ duplicates removed
Reply
1 Reply 1
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 05, 2023 08:10 AM
Hi Kaley,
A way to use ARRAYUNIQUE() in a lookup field to dedupe values would be a great addition to the product. You're right! You can do this with a rollup field, but it does remove the formatting. I encourage you to post this idea in the Product Ideas section as I am sure others might be looking for similar functionality.
Reply
![](/skins/images/FE00829FDD2AE889FAB731D8F02A8942/responsive_peak/images/icon_anonymous_message.png)