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