Use of MODE Function -- Not Working

Posted to microsoft.public.excel.programming

AJ[_6_]

external usenet poster

Posts: 2

Use of MODE Function -- Not Working

I'm confused. I'm using Excel 2000 and I cannot get the below formula
to work. I only get #####. The strange thing is that if I change MODE
to AVERAGE or MEDIAN it works fine -- only the MODE function does not
work.

=MODE(Firstsheet:LastSheet!C5:C20)

Thanks if you can help . . . .

AJ

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formulas and Dates not working in compatibility mode	AOA	Excel Discussion (Misc queries)	2	January 8th 10 06:42 PM
Mode Function or MODE Function -- Can't get it to work!!	JoAn	Excel Discussion (Misc queries)	5	November 4th 09 12:08 AM
Mkae Mode function return "" instead of #N/A when there is no Mode	Tonso	Excel Discussion (Misc queries)	1	March 11th 07 10:38 AM
Mkae Mode function return "" instead of #N/A when there is no Mode	Tonso	Excel Discussion (Misc queries)	2	March 10th 07 05:10 PM
MODE isn't working properly.	M Keeler	Excel Worksheet Functions	1	September 8th 05 03:30 AM

All times are GMT +1. The time now is 05:31 PM.

Menu

About Us