formulas
Posted by rich on February 05, 2002 10:43 AM
=IF(AMSER!H11>0,AMSER!C11,IF(AMSER!H19>0,AMSER!C19,IF(AMSER!H19=0,"")))
this is what i have now but i need it to work for up to 20 to 40 not just 2
did a drop down box for now but would like one that up dates on it's own.
other question a macro to just send an e-mail of only certian pages of this work book.
Posted by Aladin Akyurek on February 05, 2002 11:18 AM
Two possible interpretations of your formula request:
[1] Array-enter: =IF(COUNTIF(AMSER!H11:H19,">0"),INDIRECT("AMSER!C"&MIN(IF(AMSER!H11:H19 > 0,(AMSER!H11:H19 > 0)*ROW(AMSER!H11:H19)))),"") [ produces a single result ]
[2] =IF(AMSER!H11,INDIRECT("AMSER!C"&ROW(AMSER!H11)),"") [ copy down as far as needed ]
Which is it Rich, if any?
================
=IF(AMSER!H11>0,AMSER!C11,IF(AMSER!H19>0,AMSER!C19,IF(AMSER!H19=0,"")))
Posted by Aladin Akyurek on February 05, 2002 11:21 AM
To array-enter...
a formula, hit control+shift+enter at the same time instead of just enter.
=========
Posted by rich on February 05, 2002 12:47 PM
Re: To array-enter...
ERR
Posted by Aladin Akyurek on February 05, 2002 1:23 PM
Re: To array-enter...
Your own first attempt and the one above tells me that you want to look in the range in H, find the first H-value that is positive ( > 0 ), and retrieve the corresponding C-value. So you really should try the array formula after adjusting it for the range in H.
Otherwise, please try to explain what you want without using a formula.
==========
Posted by rich on February 05, 2002 1:48 PM
Re: To array-enter...
What im trying to do is a schedul program where on one sheet the server names are on another is a daily work sheet.
I want to transfer people who are working that day by using the the cell where I in put there time, but since the other form only has space for limited people I want to input to the other sheet only the people who are working that day one per cell.
the above formuls work but I don't rember the code to put in if another cell has same value go to next cell.
have done this befor but for the life of me cant rember.
thanks for all the help
