Posted to microsoft.public.excel.worksheet.functions

San[_4_]

external usenet poster

Posts: 26

How to filter Unique values from Duplicates

Hi,

I have a table where one of the columns contain names of Coalfields but the column contains duplicate names.

I would like to make a separate column containing only unique names of the coalfields, sourced from the mother column.

Thanks for the help

San

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
Concatenate unique values among duplicates	Toby	Excel Worksheet Functions	6	April 15th 09 05:55 PM
Duplicates and unique values	sragor	Excel Worksheet Functions	1	February 3rd 09 08:22 AM
Identifying unique values among duplicates	bob	Excel Worksheet Functions	4	November 10th 08 09:43 PM
How do I sum unique values among duplicates horizontally	Janine Ball	Excel Worksheet Functions	2	August 10th 07 12:54 PM
Identifying duplicates/unique values	ali	Excel Programming	5	March 6th 04 10:53 PM

All times are GMT +1. The time now is 06:25 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us