(Msg. 1) Posted: Mon Oct 05, 2009 3:56 pm
Post subject: Mode Function or MODE Function -- Can't get it to work!! Archived from groups: microsoft>public>excel>misc (more info?)
I am unable to get the Mode Function to tell me the most frequently occurring
number in Column G from row 1 through 447. I place my cursor just below the
last entry in column G. I then insert the function =MODE(G1:G447) and I get
N/A references or circular reference error messages. There are no blanks and
the entire column G is formatted as numbers. PLEASE help. I've looked
everywhere!
(Msg. 2) Posted: Mon Oct 05, 2009 4:13 pm
Post subject: Re: Mode Function or MODE Function -- Can't get it to work!! [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Did you look in Excel help?
States in there that #N/A is returned if no duplicate points.
Is that your case?
Also to look at...........you say the data are formatted as numbers.
That doesn't necessarily mean Excel sees them as numbers. They could be
text in disguise.
In an adjacent column enter =ISNUMBER(G1)
D-click to copy down................TRUE or FALSE?
As far as circular references, I don't see how if your formula is outside
the range it references.
Gord Dibben MS Excel MVP
On Mon, 5 Oct 2009 15:56:01 -0700, JoAn <JoAn.TakeThisOut@discussions.microsoft.com>
wrote:
>I am unable to get the Mode Function to tell me the most frequently occurring
>number in Column G from row 1 through 447. I place my cursor just below the
>last entry in column G. I then insert the function =MODE(G1:G447) and I get
>N/A references or circular reference error messages. There are no blanks and
>the entire column G is formatted as numbers. PLEASE help. I've looked
>everywhere!
(Msg. 3) Posted: Mon Oct 05, 2009 4:21 pm
Post subject: Re: Mode Function or MODE Function -- Can't get it to work!! [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
#N/A is the correct result if there are no duplicates in the series.
For a circular reference, perhaps there is a circ ref somewhere else and
maybe Excel is coincidentally alerting you when you enter this formula.
"JoAn" <JoAn DeleteThis @discussions.microsoft.com> wrote in message
news:849968FE-89F2-43EF-80AE-BEE5A904C272@microsoft.com...
>I am unable to get the Mode Function to tell me the most frequently
>occurring
> number in Column G from row 1 through 447. I place my cursor just below
> the
> last entry in column G. I then insert the function =MODE(G1:G447) and I
> get
> N/A references or circular reference error messages. There are no blanks
> and
> the entire column G is formatted as numbers. PLEASE help. I've looked
> everywhere!
(Msg. 4) Posted: Mon Oct 05, 2009 4:30 pm
Post subject: RE: Mode Function or MODE Function -- Can't get it to work!! [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
If you're getting a circular reference error, make sure that your MODE
formula is not referencing the cell in which it is written. If the formula is
in G448, you shouldn't get this error unless it's from somewhere else.
As for the #N/A error, the MODE function returns this error message if all
values in the range are unique.
Rob
--
Powered by Creative Laziness
"JoAn" wrote:
> I am unable to get the Mode Function to tell me the most frequently occurring
> number in Column G from row 1 through 447. I place my cursor just below the
> last entry in column G. I then insert the function =MODE(G1:G447) and I get
> N/A references or circular reference error messages. There are no blanks and
> the entire column G is formatted as numbers. PLEASE help. I've looked
> everywhere!
(Msg. 5) Posted: Tue Oct 06, 2009 3:00 am
Post subject: RE: Mode Function or MODE Function -- Can't get it to work!! [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Another small point, you say that the data is formatted as numbers, if these
are by a calculation say X * .075 and you have formatted the number to say,
one decimal place then two number may look the same but in fact be slightly
different. Always use the round function to get the same results. e.g.
=ROUND(youcalulation,2) calculates each formula to 2 decimal places.
HTH, Peter A
"JoAn" wrote:
> I am unable to get the Mode Function to tell me the most frequently occurring
> number in Column G from row 1 through 447. I place my cursor just below the
> last entry in column G. I then insert the function =MODE(G1:G447) and I get
> N/A references or circular reference error messages. There are no blanks and
> the entire column G is formatted as numbers. PLEASE help. I've looked
> everywhere!
(Msg. 6) Posted: Tue Nov 03, 2009 4:08 pm
Post subject: RE: Mode Function or MODE Function -- Can't get it to work!! [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
I appreciate everyone's answers, but nothing has worked. I have even copied
the numbers onto a blank worksheet to find the most frequently occurring
number in that row using the MODE function. Interestingly, AUTOSUM doesn't
work after I cut and paste numbers, so there is something very wrong in my
2007 Excel. If I don't cut and paste, AUTOSUM works.
> I am unable to get the Mode Function to tell me the most frequently occurring
> number in Column G from row 1 through 447. I place my cursor just below the
> last entry in column G. I then insert the function =MODE(G1:G447) and I get
> N/A references or circular reference error messages. There are no blanks and
> the entire column G is formatted as numbers. PLEASE help. I've looked
> everywhere!
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office