#N/A in mode worksheet function

B

broer konijn

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!
 
L

Larry S

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" <[email protected]>
wrote in message
news:[email protected]...
 
D

Domenic

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?

broer konijn
 
B

broer konijn

Domenic,

I found out, just before your advice, that indeed the data was text.
swithed off the announcements in Excel, therefore I did not notice. Th
data is exported from a database, therefore it was apparently tekst fro
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!
 
Top