Posted to microsoft.public.excel.programming

Mike Fogleman[_2_] Mike Fogleman[_2_] is offline

external usenet poster

Posts: 206

Chip Pearson's DistinctValues function

BTW, Chip's site is throwing an error right now.

How can I get the array of distinct values results into a single cell
delimited with a comma?

InputRange
A2| E01AB
A3| E01AB
A4| E01CD
A5| A11

Output
AE15| E01AB,E01CD,A11

The input and output ranges will be determined with VB.
Mike F

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
Chip Pearson's NewWorkDays formula	Pete Rooney	Excel Discussion (Misc queries)	9	August 9th 08 01:57 AM
Trouble exporting using Chip Pearson's export	dan dungan	Excel Programming	7	September 28th 07 05:20 PM
DeleteDuplicatesViaFilter From Chip Pearson's Website	JohnHB	Excel Programming	1	April 11th 07 09:06 PM
How to Use Chip Pearson's Text Import Code	[email protected]	Excel Programming	12	August 23rd 06 02:28 PM
Chip Pearson's Forum Etiquette	Gary L Brown	New Users to Excel	0	January 20th 06 07:22 PM

All times are GMT +1. The time now is 09:18 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us