Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
EXCEL FUNCTIONS
I WANT TO SORT NUMBERS, ODD FROM EVEN, AND THE MOST PREFERRED IN A GROUP OF
23 NUMBER. HELP? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
EXCEL FUNCTIONS
DAZZER wrote:
I WANT TO SORT NUMBERS, ODD FROM EVEN, AND THE MOST PREFERRED IN A GROUP OF 23 NUMBER. HELP? Please turn off your caps lock before typing. If you have some integer numbers in column A you can determine whether they are even or odd by entering this formula in a new column: =MOD(A1,2) A result of 0 means even; 1 means odd. Sort on this new column. Not sure what you mean by "most preferred in a group of 23"? Can you explain this a bit? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
EXCEL FUNCTIONS
Perhaps
=MODE(A1:A23) In article , smartin wrote: Not sure what you mean by "most preferred in a group of 23"? Can you explain this a bit? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple functions, conditional functions | Excel Worksheet Functions | |||
How to convert cell formula functions to code functions | Excel Discussion (Misc queries) | |||
efficiency: database functions vs. math functions vs. array formula | Excel Discussion (Misc queries) | |||
Looking for a site with functions that substitute the ATP functions | Excel Worksheet Functions | |||
Nesting functions in the functions dialog box | Excel Worksheet Functions |