Posted to microsoft.public.excel.programming

ace

external usenet poster

Posts: 19

Range problem

Guys,

i have a data set thus,
20
21
21.5
27
24
0
0
19.5

Now the range formula will take 27-0 and give me the answer as 27
but if I want the zeros to be discounted from the range formula is it
possible??
that is i want the range formula to take the max as 27 and in this case the
minimum as 19.5, can it be done??

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 function for a Range failing in excel 2003 and giving subscriptout of range error 9 problem but works fine in excel 2000	Prince	Excel Programming	5	February 10th 09 05:47 PM
Range problem	Jac Tremblay[_4_]	Excel Programming	9	November 11th 08 08:53 PM
Range problem	Valeria	Excel Programming	4	November 30th 07 08:44 AM
Range problem	Ali Baba	Excel Programming	1	September 10th 05 01:10 AM
getting value of range problem	Grant	Excel Programming	1	September 23rd 04 06:20 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us