Searching in tables
When you search in tables, you can search directly for numeric values or text such as product numbers or company names, or look up values in related tables.
For direct searches, you can also use search operators to refine your search.
| Operator | Definition | Example | Comment |
|---|---|---|---|
| > | Greater than | "> 5" - greater than 5 | |
| >= |
Greater than or equals "1.." - greater than or equals 1 (same as ">= 1") |
">= 5" - greater than or equals 5 | |
| < | Less than | "< 5" - less than 5 | |
| <= | Less than or equals | "<= 5" - less than or equals 5 | Can also be expressed "..5" |
| <> | Not equal to | "<>100" - not equal to 100 | Can also be expressed "!=100" |
| | | Or | "1|2" - 1 or 2 | Can also be expressed "1;2" |
| .. | From - to | "1..5" - from 1 to 5 |
See also: Looking up a value in another table
Learn more by visiting the Learning Universe (in Norwegian).