Posted to microsoft.public.excel.programming

Atishoo

external usenet poster

Posts: 267

small function

=SMALL(--LEFT(I18:I30,3),1)

how do I get this function to ignore empty cells in the range I18:I30 and to
still work when some of the numbers are less than 3 numbers in length (there
is text as well in some cells thats why I have limited it to 3 numbers.)

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
SMALL function	Wally3178	Excel Worksheet Functions	7	May 20th 08 09:52 AM
How to use small function?	Eric	Excel Discussion (Misc queries)	10	July 16th 07 01:28 PM
Small Function	Shankidi	Excel Worksheet Functions	4	February 19th 07 11:36 PM
SMALL function	[email protected]	Excel Discussion (Misc queries)	2	January 26th 07 06:38 PM
SMALL function if 0	Louis	Excel Worksheet Functions	5	September 29th 06 06:46 PM

All times are GMT +1. The time now is 07:27 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us