CODEWITHSUNDEEP
excel
Reed
Reed

Reputation: 1642

Filter table by last digit in cell value

Just as the title states. I need to filter or sort a table based on the last digit in a column cell. I've looked into advanced filters, but can't seem to get any to do what I'd like.

Upvotes: 0

Views: 226

Answers (1)

Gowtham Shiva
Gowtham Shiva

Reputation: 3875

Just use a helper column like below and sort of filter accordingly,

enter image description here

Column B formula: 

=RIGHT(A2)

Filtered table:

enter image description here

Sorted list:

enter image description here

Upvotes: 1

Related Questions