Posted to microsoft.public.excel.misc

external usenet poster

Posts: 32

Min. Value is Needed

I am trying to determine the min value of a column using the MIN command.

The column has the following values:
2
34
6
0
0
1

I would the minium value greater then zero to be displayed in a cell. I
have been able to use the Max command to determine the mx number but and Min
command displays 0 or if I setup a negative number it will display that
value.

Any suggestions?

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
Needed Help..	Chaos2blue	Excel Worksheet Functions	5	September 1st 06 09:06 AM
Help needed	Monty	New Users to Excel	1	July 31st 06 09:40 AM
Help needed	Gary	Excel Worksheet Functions	5	July 19th 06 02:36 AM
Help Needed - Please	Bradley Bell	Excel Discussion (Misc queries)	2	January 18th 06 08:43 AM
help needed	zomex	Excel Worksheet Functions	5	January 4th 06 12:54 PM

All times are GMT +1. The time now is 04:43 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us