| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summarising a range in a column into a separate column
highlight your column
Data==Filter=AdvancedFilter==Copy to another location... select your cell and then click "Unique values only" "Aidan" wrote: If I have a column with say car, boat, train, other I want to generate a separate column that only shows one incidence of each of the words (the words appearing one below the other). I'd appreciate any help on this. Thanks, Aidan. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COUNTIF: 2 criteria: Date Range Column & Text Column | Excel Worksheet Functions | |||
| Summarising a range in a column into a separate column | Excel Worksheet Functions | |||
| Summarising a column of numbers | Excel Discussion (Misc queries) | |||
| EXCEL Sum column based on time range in different column? | Excel Worksheet Functions | |||
| CountIf first column range = "Word" and second column range <> 0 | Excel Worksheet Functions | |||
Linear Mode
