UNIQUE

UNIQUE helps you return distinct, non-duplicate values from a range in DBSheet formula fields. It provides the tools you need to extract unique results from referenced data, making your work more efficient and helping you accomplish tasks with ease. With UNIQUE, you can create a formula field, enter the function with flexible parameter formatting, use a target range such as A1:A100, and combine the result with other functions such as IF or AND in nested formulas. Results are calculated immediately after saving, refresh automatically when source data changes, and are also filled automatically after data import. Whether you're setting up formulas, troubleshooting parameter or data-type errors, or testing formulas before applying them more broadly, UNIQUE helps you stay productive and complete tasks efficiently. Choose the documentation below that best matches your needs to learn more.

1:53