lundi 21 août 2017

EXCEL: Find cells via last number

So I need a way to mark the cells where the sequence ends in 4, 5, or 6.

Data
35632
35215
35115
etc.

I don't have an idea of where to start so any help is much appreciated. I know that I can't use the text filters on numbers even if the cell is formatted as text.

Aucun commentaire:

Enregistrer un commentaire