Excel |
| Member name | Value | Description |
|---|---|---|
| Ascending | 0 | From the smallest to the largest: numbers and dates, then texts from A to Z, then FALSE and TRUE, then errors. |
| Descending | 1 | From the largest to the smallest: errors, TRUE and FALSE, texts from Z to A, then numbers and dates. |