| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
UDF Sort Function
Hi -
I need a UDF that can sort a column of text and weed out duplicates. If the weeding of duplicates is not possible I'll just take the sort function. I can't use Excel's sort function because I need the sort to happen dynamically when the user enters text in column A. Some cells in column A could be blank. Col A contains text strings like GGG BBB <blank CCC AAA FFF <blank BBB GGG <blank HHH AAA LLL so with the proper UDF Column B would look like this AAA BBB CCC FFF GGG HHH LLL Any help would be greatly appreciated! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sort function for dates does not sort properly in Office 2007 Exc. | Excel Worksheet Functions | |||
| Sort : how can I use a variable in a VB sort function? | Excel Worksheet Functions | |||
| sort function to sort for bell curve | Excel Discussion (Misc queries) | |||
| Complicated sort function with sort and sum | Excel Worksheet Functions | |||
| Excel Sort function should not sort the cell formatting! | Excel Worksheet Functions | |||
Threaded Mode
