Sort By Currency Sign NOT Values

Dear all,

I have a list of values in column A like

€ 447,325.80
$384,258.57
$358,782.34
€ 331,385.40
$306,990.83
£304,438.18
$284,294.17
£250,071.39
$222,879.52
$202,603.22
$181,621.94
€ 143,944.00
$137,240.12


I want to sort by Currency sign like all $ values come first then £ value and then €.

Please can you help.

Might be if can Extract Currency sign from cell then it will be good but how to do?


Regards
Vinay

For Excel 2007 using custom sort "sort on value" from "A - Z" I get $, then £ and finaly €

I'm I missing something?

Alf

Data>Sort>Sort on>values>order by>Custom list> Type your custom sort list >ok

Strange! I am getting below result
using Excel 2007 using custom sort "sort on value" from "A - Z"

€ 143,944.00
£250,071.39
£304,438.18
€ 331,385.40
€ 447,325.80
$137,240.12
$181,621.94
$202,603.22
$222,879.52
$284,294.17
$306,990.83
$358,782.34
$384,258.57

Its sort on Value A-Z. I don't want that.

Vinay

You have to create your custom sort list
Select the range >then click sort>it should be sort on values> order >from drop down select >custom list>$,£,€.
Just make sure your data is formatted correctly as the format cell>currency> and type or else it wont sort correctly.

Hi ALF & Pdalal,
I have tried your ways but still not working but I have got something that I want and would like to share

first need to created UDF

Function GetTextValue(ByVal arg As Range) As String
GetTextValue = arg.Cells(1, 1).Text '//Cell value (or top left cell value if range is more than one cell)
End Function

now type in Column B1=Left(=LEFT(GetTextValue(A1),2)

It will extract Currency sign from cell and then you can sort any order!

Vinay

sorry

now type in Column B1=LEFT(GetTextValue(A1),2)

Thanks
Vinay