Posted to microsoft.public.excel.misc

external usenet poster

Posts: 130

Small?

a1: 1N 1E 15

a47: 2N 5E 11

a55: 4S 3W 20

Is there a way to list or sort this column range and display the smallest in
another cell ( b1) much like you would when using the SMALL function?
Between the cells are blanks.
Thanks in advance

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to 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
One small question...	VIVEKMANE	Excel Discussion (Misc queries)	3	November 8th 07 02:42 PM
ISERROR,SMALL,INDEX, MATCH, SMALL??	M.A.Tyler	Excel Discussion (Misc queries)	1	May 2nd 07 04:08 AM
datalabel box is too small	BJ	Charts and Charting in Excel	1	March 19th 07 12:06 PM
Using Small	PH NEWS	Excel Worksheet Functions	2	July 27th 06 09:22 AM
Small	tom	Excel Discussion (Misc queries)	2	July 11th 06 05:46 PM

All times are GMT +1. The time now is 09:50 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us