Filter Currency wise amount

[helpexce]

How can I filter a list of numbers in different currency e.g. in $, eur, yen for amounts with one or more currency?

 

[mole999]

you could try a cutom filter that contains $ or £ etc

 

[helpexce]

The contains option in custom filter doesn't help. Can you please suggest me with any other option?

As the $ or euro symbol is just an display, i think it need something different.

 

[helpexce]

The amounts are in currency formats.

 

[mole999]

then i think you need a helper cell, that says =left(A1,1) pointing at the cell with the money value and you can filter on the sign

 

[helpexce]

It doesn't help too. The amounts are numbers and not text and in currency format. Can you please help me find a solution to this? Thanx.

 

[helpexce]

Amount

$ 123.00 <tbody> </tbody>

£ 125.00 <tbody> </tbody>

€ 124.00 <tbody> </tbody>

￥128.00

$129.00

€130.00 <tbody> </tbody>

$131.00

<tbody>
</tbody>

I could not remove the boxes inside the table. Sorry for that.
How can I apply filter so that it displays only values with the currency/ies i need.
Please help. Thanks in advance.

 

[helpexce]

Anybody please.

 

[Harry Flashman]

Anybody please.

I found this UDF by Andrew Poulsom.

User a helper column - The function is call GetCurrency and it will return the currency symbol (assuming the formatting is valid).

For example =GetCurrency(A2)

http://www.mrexcel.com/forum/excel-...urrency-symbol-visual-basic-applications.html

Function GetCurrency(Rng As Range) As String
    If IsNumeric(Left(Rng.Text, 1)) Then
        GetCurrency = ""
    Else
        GetCurrency = Left(Rng.Text, 1)
    End If
End Function

 

[helpexce]

Thank You Harry Flashman. It worked as I needed.
But I have a question. Why doesn't a left worksheet function work but a left function in vba does?
Thanks again.

Regards,