how to determine if a series of numbers contain odd or even va
This answer was the easiest and most helpful. The MOD answer worked, but
this is the easiest to remember. I added this to a macro, so I can use it
whenever I am filtering data by serial number.
"RagDyer" wrote:
With ATP installed:
=ISEVEN(A1)
And copy down.
Filter on and delete the "True" rows.
If serial numbers are alpha-numeric, try:
=ISEVEN(RIGHT(A1))
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Kittysaid" wrote in message
...
I have lists of numbers that have a unique serial number. I would like to
delete the rows that contain EVEN serial numbers.
|