Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting in Excel | Excel Discussion (Misc queries) | |||
Sorting VLookup vs Sorting SumProduct | Excel Discussion (Misc queries) | |||
Excel Sorting | Excel Discussion (Misc queries) | |||
Sorting in Excel | Excel Discussion (Misc queries) | |||
sorting with excel | New Users to Excel |