CODEWITHSUNDEEP
excelexcel-formula
tmn
tmn

Reputation: 11569

Excel - Filter Numeric Values using "End With"

My colleague noticed something funny with Excel. If you have numeric values, and you are trying to use a custom filter that "Ends with" .13, as shown below

It filters and removes everything, rather than narrowing to only the 56.13 value.

Is there a way to accomplish this so it yields the 56.13? Hopefully without creating extra columns with text/numeric conversion operations?

Upvotes: 0

Views: 4822

Answers (1)

Gary's Student
Gary's Student

Reputation: 96771

Usually EndsWith only applies to Text, but here is a tiny trick:

In C2 enter:

=TEXT(B2,"General")

and copy down.

Then apply your filter criteria to column C:

enter image description here

which results in:

enter image description here

Because its a secret, please don't tell anyone else.

Upvotes: 1

Related Questions