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.