Sorting in Excel
 

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

Sorting in Excel
 

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

Sorting in Excel
 

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

Sorting in Excel
 

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

"Aqib Rizvi" wrote in message
...
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

Sorting in Excel
 

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

"Meebers" wrote in message
...
How about the formula "ISODD". Filter by "true"

"Aqib Rizvi" wrote in message
...
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

Sorting in Excel
 

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

Pete

On Nov 19, 2:21 am, "Meebers" wrote:
Should have been "ISEVEN" ...what you asked for.

"Meebers" wrote in message

...



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

"Aqib Rizvi" wrote in message
...
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- Hide quoted text -

- Show quoted text -