#N/A in mode worksheet function

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

broer konijn - 15 Jun 2006 19:18 GMT

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!

Signature

broer konijn

Reply to this Message

Larry S - 15 Jun 2006 19:29 GMT

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.

> Can anyone telle me when #N/A occurs as the answer to an worksheet
> function?
[quoted text clipped - 14 lines]
>
> Thanx!

Reply to this Message

Domenic - 15 Jun 2006 19:38 GMT

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.29gh30_1150395531.5036@excelforum-nospam.com>,
broer konijn
<broer.konijn.29gh30_1150395531.5036@excelforum-nospam.com> wrote:

> Can anyone telle me when #N/A occurs as the answer to an worksheet
> function?
[quoted text clipped - 14 lines]
>
> Thanx!

Reply to this Message

broer konijn - 15 Jun 2006 23:55 GMT

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!

Domenic Wrote:

> Maybe the numbers are being recognized as text values by Excel. Tr
> the
[quoted text clipped - 33 lines]
> >
> > Thanx

Reply to this Message