Posted to microsoft.public.excel.misc

scott

external usenet poster

Posts: 577

minimum formual help

Simple but can not get this. I have just 12 cells need to pick out the
minimum excluding 0. Tried =min(if(b1:b13<0)) and entered as an arrary.comes
back as error with 0 highlighted. Any help would be appreciated

Thanks Scott

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
Formual	Jodi	Excel Worksheet Functions	1	May 16th 07 01:03 AM
WHAT DOES FORMUAL =C8+ 15 DO	Tara	Excel Discussion (Misc queries)	1	January 4th 07 03:38 PM
Formual	Winnie	Excel Discussion (Misc queries)	1	November 13th 06 10:19 AM
Set Formual	Winnie	Excel Discussion (Misc queries)	2	November 13th 06 09:47 AM
How to lookup the minimum, 2nd minimum and 3rd minimum.........	Mark McDonough	Excel Worksheet Functions	8	July 15th 06 09:39 PM

All times are GMT +1. The time now is 02:14 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us