#N/A in mode worksheet function

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

[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]...
>
> 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
>

[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?

In article <[email protected]>,
broer konijn
<[email protected]> 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]

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!

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 <[email protected]>,
broer konijn
<[email protected]> 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!