Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Show unique data from a row in a cell without duplicates

I have attempted to submit this same question, but it has not reached the
forum for some reason. Any assistance is most appreciated...

In Excel 2003, I have duplicate billing codes within a row of columns. How
do I show the unique billing codes (removing duplicates) and put the result
at the end of each row?

Original looks like this: J1234 J1234 S9999 *C1234 J1234
How can I make it look like this in the last cell: J1234, S9999, *C1234

How do I remove the duplicates?... thanks in advance for your help... Yolanda.
Reply
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
How do I sum unique values among duplicates horizontally Janine Ball Excel Worksheet Functions 2 August 10th 07 12:54 PM
Sum duplicates unique values and delete dupliques Dave Excel Worksheet Functions 1 June 7th 07 01:02 PM
check for duplicates, then sum unique values Weissme Excel Discussion (Misc queries) 0 August 9th 06 04:35 PM
Deleting Duplicates, All records unique mirdonamy Excel Discussion (Misc queries) 7 January 11th 06 09:59 PM
Duplicates - deleting to get just unique ones koncept New Users to Excel 3 August 24th 05 06:41 PM


All times are GMT +1. The time now is 06:05 AM.

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

About Us

"It's about Microsoft Excel"