LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #22   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default List Disctinct Strings from Range of Cells

Welcome. Suggest you start a new thread just focusing on the true alphabetic
sort issue. To recollect, what I gave earlier does perform both
functionalities that you seek in one go: List uniques and alpha sort by 1st
letter
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"golddave via OfficeKB.com" <u54833@uwe wrote in message
news:9c4280a746d61@uwe...
I have it working now. Good stuff. I see what you mean about the way it
alphabetizes. Is there a way to get it to alphabetize better?



 
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
Detect strings in a range Rich57 Excel Worksheet Functions 4 January 1st 08 12:00 AM
List disctinct values cindi Excel Worksheet Functions 10 August 16th 07 12:24 AM
strings in a range Peter Morris Excel Worksheet Functions 4 September 5th 06 01:00 AM
How to find number of pairs of strings from list of strings? greg_overholt Excel Worksheet Functions 5 January 27th 06 10:42 PM
Condensing a list/range with blank cells to a new list/range without blanks KR Excel Worksheet Functions 4 July 5th 05 04:23 PM


All times are GMT +1. The time now is 04: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"