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