Michael Rekas

Posts: n/a

Thanks Ken

I like it!

Regards

Michael

On Sat, 29 Jan 2005 15:14:22 -0000, "Ken Wright"
wrote:

=SMALL(IF(A1:A100,A1:A100),2) array entered using CTRL+SHIFT+ENTER will
ignore 0s and blanks

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
Passing a range name as an argument to the Index Function	Michael Sharpe	Excel Discussion (Misc queries)	3	September 5th 12 01:33 PM
ClearContents method on a passed range	bryan	New Users to Excel	2	January 19th 05 08:49 AM
Ranking cells largest to smallest	jim314	Excel Discussion (Misc queries)	1	January 10th 05 09:01 PM
named range refers to: in a chart	Spencer Hutton	Excel Discussion (Misc queries)	1	December 14th 04 10:15 PM
range names	Pedro	Excel Worksheet Functions	1	November 9th 04 06:27 PM

All times are GMT +1. The time now is 08:55 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us