Posted to microsoft.public.excel.misc

Abnerz

external usenet poster

Posts: 10

Lowest number above 0

If I have a list of numbers in colum "A".

A1: 10
A2: 20
A3: 00
A4: 15
A5: 50
A6: 25
I can get my answer by using this formula
=SMALL(A1:A5,COUNTIF(A1:A5,0)+1)

However, if I want the smallest number between certain cells like A1, A3, A4
which would give me an answer of 10, is that posible??

Thanks in advance

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
Lowest number	The Countryman	Excel Worksheet Functions	5	January 5th 07 01:08 AM
lowest number in a set EXCLUDING zero	Bad Kitty	Excel Worksheet Functions	2	November 3rd 06 10:34 PM
find the lowest value in a row and add a number to it	Kim	Excel Worksheet Functions	4	September 28th 05 05:27 PM
lowest number above 0	One-Leg	Excel Discussion (Misc queries)	9	May 27th 05 09:24 AM
how to subtract the very next LOWEST number	maxkofe	New Users to Excel	2	December 5th 04 06:06 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us