I have lists of numbers that have a unique serial number. I would like to
delete the rows that contain EVEN serial numbers.

If they are NUMBERS, check if exactly divisible by 2

e.g. =IF(MOD(A1,2)=0,"delete","keep")

You could filter on "Delete" and then delete these rows

HTH


"Kittysaid" wrote:

I have lists of numbers that have a unique serial number. I would like to
delete the rows that contain EVEN serial numbers.

If they are a mixture of letters and numbers then you could just
examine the final digit:

=IF(MOD(RIGHT(A1,1),2)=0,"delete","keep")

Hope this helps.

Pete

Toppers wrote:
If they are NUMBERS, check if exactly divisible by 2

e.g. =IF(MOD(A1,2)=0,"delete","keep")

You could filter on "Delete" and then delete these rows

HTH


"Kittysaid" wrote:

I have lists of numbers that have a unique serial number. I would like to
delete the rows that contain EVEN serial numbers.

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.

Hi kitty you are quite tricky...the guys gave a lot but no reply...Guys,
look for help about meaning of "delete the rows that contain EVEN serial
numbers"...Type on cell A1:=row(a1)=1
A2:=ROW(a2)=2
how to delete a standard excel row???

"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.

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.

Appreciate the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Kittysaid" wrote in message
...
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.