Sorting in Excel

[Guest]

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!

 

[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

 

[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

 

[Meebers]

How about the formula "ISODD". Filter by "true"

 

[Meebers]

Should have been "ISEVEN" ...what you asked for.

 

[Pete_UK]

Note: use of ISODD and ISEVEN requires Analysis Toolpak to be
installed.

Pete