Need a book? Engineering books recommendations...

Return to index: [Subject] [Thread] [Date] [Author]

Re: Two Spreadsheet Questions

[Subject Prev][Subject Next][Thread Prev][Thread Next]
You should be able to do prob 1 using nested condition statements ...
probably 2 also.

----- Original Message -----
From: <Seaintonln(--nospam--at)aol.com>
To: <seaint(--nospam--at)seaint.org>
Cc: <MarkD(--nospam--at)danddeng.com>
Sent: Monday, October 11, 1999 6:02 PM
Subject: Two Spreadsheet Questions


> I need some help. Here are two problems that I need to resolve and I could
> use some advice from you spreadsheet experts out there.
>
> Problem 1: I want to find the maximum and minimum values for a column of
> numbers and wish to ignore all zero values. In otherwords, how do I find
the
> minimum values of all numbers in a list greater than zero?
>
> Problem 2: When creating a chart that draws the perimeter of a building
from
> the coordinate input the starting point and ending point are the same.
> However, if there are more values in the column than are needed, the
excess
> values are left simply as zeros.
> When charting from my input, the last point entered is connected back to
the
> origin on the graph. I wish to have it ignore the zero values and graph
only
> the values that start and end on the same point.
> Can anyone help me on these two problems????
>
> Thanks
> Dennis Wish PE
>