Вопрос по Excel. Select DISTINCT(Column)...
Нашел только в хелпе Excel:
Count the number of unique values
For example, if a column contains 1,2,2,2 the result is 2 unique values in the column.
On the Data menu, point to Filter, and then click Advanced Filter.
In the Advanced Filter dialog box, click Copy to another location.
In the List range box, delete any information in the box or click the box, and then click the column for which you want to count the unique entries.
If you have a column label, in the Criteria range box, delete any information in the box or click the box, and then click the column label for your column of data.
In the Copy to box, delete any information in the box or click the box, and then click a blank column where you want to copy the unique values.
Select the Unique records only check box, and click OK.
Select the blank cell below the last cell in the list.
Click the arrow next to AutoSum on the Standard toolbar, and then click Count.
Press Enter
Count the number of unique values
For example, if a column contains 1,2,2,2 the result is 2 unique values in the column.
On the Data menu, point to Filter, and then click Advanced Filter.
In the Advanced Filter dialog box, click Copy to another location.
In the List range box, delete any information in the box or click the box, and then click the column for which you want to count the unique entries.
If you have a column label, in the Criteria range box, delete any information in the box or click the box, and then click the column label for your column of data.
In the Copy to box, delete any information in the box or click the box, and then click a blank column where you want to copy the unique values.
Select the Unique records only check box, and click OK.
Select the blank cell below the last cell in the list.
Click the arrow next to AutoSum on the Standard toolbar, and then click Count.
Press Enter
Оставить комментарий
xz_post
Скажем есть одна колонкаA
--------------
12
2
3
11
1
2
--------------
Хочу получить число различных ячеек в этом диапазоне (в данном случае 5). Т.е. Хочу сделать примерно такой запрос select DISTINCT(A)... Какую функцию надо испоотльзвать. Подозреваю, что из категории DataBase. Но как тогда задать критерий ?
Спасибо!