ID Values

W

wal50

The Data
A B C
1 50 80 0
2 0 0 100
3 75 0 90
4 60 70 80
5 45 50 0

The three columns in each row can have 1, 2 or 3 non-zero numbers (but will
always have at least one). The numbers/zeros can be in any column. I need
column D to show the number if there is only one non-zero, the lowest if
there are two, and the middle number if there are three non zero. In the
example D1 and down would be 50, 100, 75, 70 and 45

Thanks
WAL50
 
B

Bob Phillips

=MIN(IF(A1:C1>0,A1:C1))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)
 
B

Bob Phillips

Forget that please, missed the middle bit.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top