LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
SteveT
 
Posts: n/a
Default Concatenate Unique Entries

The first column in my range is a list of customers, columns 2-8 represent
days of week, headers Mon, Tue, Etc. In the days of the week portion of the
range we list a code that representing the Courier Co. that picks up the
order.

ie)
A B C D E F G
1 Customer Mon Tue Wed Thur Fri Sat
2 AAA FX FX UPS
3 ABC FX BAX FX
4 TTT FX UPS
5 XYZ FX FX FX


I want to concatenate in column H all the Courier companies used to ship
orders out but eliminate the duplicates and put a comma in between ea unique
co.

Thanks for your help.
Steven

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Count Unique Entries SouthCarolina Excel Worksheet Functions 4 April 14th 06 11:44 PM
Counting Unique Entries SouthCarolina Excel Discussion (Misc queries) 7 April 14th 06 01:18 PM
Count unique entries Cash Excel Discussion (Misc queries) 4 April 4th 06 09:44 PM
Best way to get a list of unique entries in a field [email protected] Excel Worksheet Functions 2 January 19th 06 10:30 PM
how to count unique entries with multiple condition Michael Excel Worksheet Functions 6 June 29th 05 12:38 PM


All times are GMT +1. The time now is 12:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"