You can add another column and put a formula in like:

=IF(MOD(money,2)=0,"Even","odd")

where money is the first cell containing your monetary units - copy
this down the column.

Now you could apply autofilter to this column and select Even from the
filter pull-down, and this will show you only the even numbers.

Alternatively, you could sort the data using this field as the 1st
sort field and monetary value as the second sort field. This would
give you a block of all the even numbers, followed by a block of all
the odd numbers (which could be deleted if required).

Hope this helps.

Pete

On Nov 18, 8:30 pm, RDH wrote:
Hi, I have a databse of information to sort. I would like to identify even
numbers only in the databse filed of "monetary ($) units", to identify
unusual transactions. Can anyone help with how to customize the sort feature
in excel to display only even numbers? Thanks!
--
-RDH