Thread: how to determine if a series of numbers contain odd or even values
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RagDyeR RagDyeR is offline
external usenet poster
  
Posts: 3,572
Default how to determine if a series of numbers contain odd or even values
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.

Reply With QuoteReply With Quote