Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#N/A in mode worksheet function
Can anyone telle me when #N/A occurs as the answer to an worksheet function? If I try to find the mode of the list of codes below, I get #N/A 7372 7379 7379 7379 7372 7375 Does this have anything to do with the first two digits being equal? How do I workaround? I am trying to find the most frequent ocurring code in the list. By the way, how does the mode work if out of 4 values, both pairs of two are equal? Thanx! -- broer konijn ------------------------------------------------------------------------ broer konijn's Profile: http://www.excelforum.com/member.php...o&userid=34402 View this thread: http://www.excelforum.com/showthread...hreadid=552394 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#N/A in mode worksheet function
I tried your group/list of numbers and MODE returned 7379 as expected.
Looking at EXCEL's internal help "If the data set contains no duplicate data points, MODE returns the #N/A error value." I tested this on your list of number and deleting the duplicate 7379 resulted in 7372. When I deleted the duplicate 7372, I got the #N/A. "broer konijn" wrote in message news:broer.konijn.29gh30_1150395531.5036@excelforu m-nospam.com... Can anyone telle me when #N/A occurs as the answer to an worksheet function? If I try to find the mode of the list of codes below, I get #N/A 7372 7379 7379 7379 7372 7375 Does this have anything to do with the first two digits being equal? How do I workaround? I am trying to find the most frequent ocurring code in the list. By the way, how does the mode work if out of 4 values, both pairs of two are equal? Thanx! -- broer konijn ------------------------------------------------------------------------ broer konijn's Profile: http://www.excelforum.com/member.php...o&userid=34402 View this thread: http://www.excelforum.com/showthread...hreadid=552394 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#N/A in mode worksheet function
Maybe the numbers are being recognized as text values by Excel. Try the
following... 1) Select an empty cell 2) Edit Copy 3) Select your range of cells 4) Edit Paste Special Add Ok Does this help? In article , broer konijn wrote: Can anyone telle me when #N/A occurs as the answer to an worksheet function? If I try to find the mode of the list of codes below, I get #N/A 7372 7379 7379 7379 7372 7375 Does this have anything to do with the first two digits being equal? How do I workaround? I am trying to find the most frequent ocurring code in the list. By the way, how does the mode work if out of 4 values, both pairs of two are equal? Thanx! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#N/A in mode worksheet function
Domenic, I found out, just before your advice, that indeed the data was text. I swithed off the announcements in Excel, therefore I did not notice. The data is exported from a database, therefore it was apparently tekst from a certain point. I discovered it when I used F enter in each cell. Ctrl+C alt+es (paste special) of values would work indeed. Thanks! I credit you for solving this! Domenic Wrote: Maybe the numbers are being recognized as text values by Excel. Try the following... 1) Select an empty cell 2) Edit Copy 3) Select your range of cells 4) Edit Paste Special Add Ok Does this help? In article , broer konijn wrote: Can anyone telle me when #N/A occurs as the answer to an worksheet function? If I try to find the mode of the list of codes below, I get #N/A 7372 7379 7379 7379 7372 7375 Does this have anything to do with the first two digits being equal? How do I workaround? I am trying to find the most frequent ocurring code in the list. By the way, how does the mode work if out of 4 values, both pairs of two are equal? Thanx! -- broer konijn ------------------------------------------------------------------------ broer konijn's Profile: http://www.excelforum.com/member.php...o&userid=34402 View this thread: http://www.excelforum.com/showthread...hreadid=552394 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Passing a WorkSheet from a Function??? | Excel Worksheet Functions | |||
numerical integration | Excel Discussion (Misc queries) | |||
Changing worksheet cells from within a function | Setting up and Configuration of Excel | |||
changing type style and colour within a worksheet function | Excel Worksheet Functions | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel |