Is this lookup possible?....

  • Thread starter Thread starter Dan B
  • Start date Start date
D

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
 
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)
 
That will work for me.
Thanks.


Frank Kabel said:
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)
Click to expand...
 
Back
Top