| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get number of different values in a column
Hi
How do i get the number of different value in a column with for example 100 rows where a number of rows have the same value. Example Column: Sam Tom Sam Pete Pete Result: Sam Tom Pete Autofilter is not an option. Regards, Claus |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Get number of different values in a column
Use Advanced filter which has a Unique option. It can copy you list of
unique values to another location. Data=Filter=Advanced Filter. -- Regards, Tom Ogilvy "Claus" wrote in message ... Hi How do i get the number of different value in a column with for example 100 rows where a number of rows have the same value. Example Column: Sam Tom Sam Pete Pete Result: Sam Tom Pete Autofilter is not an option. Regards, Claus |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Number of non-zero values in a column | Excel Worksheet Functions | |||
| MATCH A NUMBER AS THE SUM OF VALUES IN A COLUMN | Excel Worksheet Functions | |||
| Look up values in a column and return ALL corresponding row number | New Users to Excel | |||
| can i multipy values in a column by 1 number | Excel Worksheet Functions | |||
| Finding the max of a column where values less than a specified number | Excel Worksheet Functions | |||
![Claus[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
