Find Min of a row, but only greater than zero?

RocketDude

Posts: n/a

Thank you.

Regards,

--
Matthew

"Aladin Akyurek" wrote in message
...
=SMALL(A2:F2,COUNTIF(A2:F2,"<=0")+1)

RocketDude wrote:
Hi and sorry for the cross-posting but I'm desperate,

Does anyone know how to find the minimum of a row of numbers, but only
for
numbers greater than zero? I have over three hundred rows I need to
perform
this same function on, so naming the row is out of the question.

For example, if my row is:

0 0 0 1 2 3 5 0 0.5

I want to find "0.5".

TIA

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
Find within Workbook.	Matt Carter	Excel Discussion (Misc queries)	2	August 3rd 05 07:40 PM
if greater then 99 then 1 if greater then 199 then two	N.R.	Excel Worksheet Functions	2	June 23rd 05 06:14 PM
How do I find the cell address of the 2nd largest of a set?	Mr. Snrub	Excel Discussion (Misc queries)	4	May 30th 05 12:53 PM
Using COUNTIF to find numbers within a range greater than the mean	Lowkey	Excel Worksheet Functions	2	May 17th 05 06:34 PM
Excel has a "Find Next" command but no "Find Previous" command.	Michael Fitzpatrick	Excel Discussion (Misc queries)	2	January 10th 05 11:45 PM

All times are GMT +1. The time now is 06:42 AM.

Menu

About Us