find the value of the last digit in a cell
Something like this?
=RIGHT(A1,1)
--
Regards,
Dave
"Thruway" wrote:
I have a column of numerical values and I need to choose cells based on
whether or not the value of the ending digit in the cell is equal to 1. For
example I would want to choose a cell whose data is 12341 but not choose a
cell whose data is 1234 .
Any help is appreciated
Thank you
|