Is this lookup possible?....

[Dan B]

I have a list of numbers, all are 5 digits long. Some end with a 1 and some
with a 0. Is there a way to have Excel look at that last digit only, and if
it's a 1, copy that cell to another column?

Thanks!

Dan

 

[Frank Kabel]

Hi
one non-VBA solution:
- add a helper column with the formula
=RIGHT(A1,1)
- copy this down for all rows

Now use a filter ('Data - Filter') to get the desired rows and copy
these rows (or use an advanced filter for this)

 

[Dan B]

That will work for me.
Thanks.

Hi
one non-VBA solution:
- add a helper column with the formula
=RIGHT(A1,1)
- copy this down for all rows

Now use a filter ('Data - Filter') to get the desired rows and copy
these rows (or use an advanced filter for this)