Sorting in Excel

R

RDH

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!
 
P

Pete_UK

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
 
A

Aqib Rizvi

If you need only to 'identify' odd numbers, then another way could be
to use Format, Conditional Formatting,
HIghlight your column (say A5 to A30). In Condition 1, choose
Forumula Is and type =MOD(A5,2)=0 and define what sort of
Identification you want.
This would not require any sorting.
AQIB RIZVI
 
Top