Posted to microsoft.public.excel.worksheet.functions

kittronald kittronald is offline

external usenet poster

Posts: 162

Getting smallest number 0 in an array constant

How could you get the smallest number greater than zero in the array
constant {0,0,1,2} ?

In this case, the answer would be 1.

- Ronald K.

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
Vlookup - need the array to be constant	reesrob	Excel Worksheet Functions	2	November 18th 07 02:29 PM
Array Constant?	SayWhatAuto	Excel Discussion (Misc queries)	2	December 30th 06 02:24 PM
Array formula with a constant?	Tester	Excel Worksheet Functions	4	October 31st 06 10:44 PM
array formula with constant	name	Excel Worksheet Functions	2	May 24th 06 05:14 PM
Array constant issue	Sige	Excel Worksheet Functions	16	March 16th 06 02:56 PM

All times are GMT +1. The time now is 10:23 PM.

About Us

"It's about Microsoft Excel"