Posted to microsoft.public.excel.worksheet.functions

Aidan[_2_] Aidan[_2_] is offline

external usenet poster

Posts: 3

Summarising a range in a column into a separate column

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 With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
COUNTIF: 2 criteria: Date Range Column & Text Column	MAC	Excel Worksheet Functions	14	September 16th 08 04:39 PM
Summarising a range in a column into a separate column	Toppers	Excel Worksheet Functions	0	March 28th 07 01:50 AM
Summarising a range in a column into a separate column	karmel	Excel Worksheet Functions	0	March 28th 07 12:54 AM
Summarising a column of numbers	Keith	Excel Discussion (Misc queries)	3	July 4th 06 04:51 PM
CountIf first column range = "Word" and second column range <> 0	TinaMo	Excel Worksheet Functions	3	June 3rd 05 10:56 PM

All times are GMT +1. The time now is 10:04 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us