software

I need a function to check a Column of data and check if it is quot;Feasiblequot; or
quot;Unfeasiblequot;. In the next column of data the is measurements. I need to get
the measurements of the quot;Feasiblequot; data into of an array.
Eg.
Column a = Feasible?
Column b = Inductance (Tesla)

Feasible?Inductance (Tesla)
Feasible1,17621E-06
Feasible1,59844E-06
Feasible2,05083E-06
Feasible2,5937E-06
Feasible3,16673E-06Should end up with the inductance values in an array if they are feasible.
Thanks

=IF(A1:A100=quot;Feasiblequot;,B1:B100)

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Darren1o1quot; gt; wrote in message
...
gt; I need a function to check a Column of data and check if it is quot;Feasiblequot;
or
gt; quot;Unfeasiblequot;. In the next column of data the is measurements. I need to
get
gt; the measurements of the quot;Feasiblequot; data into of an array.
gt; Eg.
gt; Column a = Feasible?
gt; Column b = Inductance (Tesla)
gt;
gt; Feasible? Inductance (Tesla)
gt; Feasible 1,17621E-06
gt; Feasible 1,59844E-06
gt; Feasible 2,05083E-06
gt; Feasible 2,5937E-06
gt; Feasible 3,16673E-06
gt;
gt;
gt; Should end up with the inductance values in an array if they are feasible.
gt; Thanks
The value in the box then comes up as false.

quot;Bob Phillipsquot; wrote:

gt; =IF(A1:A100=quot;Feasiblequot;,B1:B100)
gt;
gt; which is an array formula, it should be committed with Ctrl-Shift-Enter, not
gt; just Enter.
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;Darren1o1quot; gt; wrote in message
gt; ...
gt; gt; I need a function to check a Column of data and check if it is quot;Feasiblequot;
gt; or
gt; gt; quot;Unfeasiblequot;. In the next column of data the is measurements. I need to
gt; get
gt; gt; the measurements of the quot;Feasiblequot; data into of an array.
gt; gt; Eg.
gt; gt; Column a = Feasible?
gt; gt; Column b = Inductance (Tesla)
gt; gt;
gt; gt; Feasible? Inductance (Tesla)
gt; gt; Feasible 1,17621E-06
gt; gt; Feasible 1,59844E-06
gt; gt; Feasible 2,05083E-06
gt; gt; Feasible 2,5937E-06
gt; gt; Feasible 3,16673E-06
gt; gt;
gt; gt;
gt; gt; Should end up with the inductance values in an array if they are feasible.
gt; gt; Thanks
gt;
gt;
gt;

It returns an array, which is what you aid you wanted. You need to do
something with that array, embed it in another formula.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Darren1o1quot; gt; wrote in message
...
gt; The value in the box then comes up as false.
gt;
gt; quot;Bob Phillipsquot; wrote:
gt;
gt; gt; =IF(A1:A100=quot;Feasiblequot;,B1:B100)
gt; gt;
gt; gt; which is an array formula, it should be committed with Ctrl-Shift-Enter,
not
gt; gt; just Enter.
gt; gt;
gt; gt; --
gt; gt; HTH
gt; gt;
gt; gt; Bob Phillips
gt; gt;
gt; gt; (remove nothere from email address if mailing direct)
gt; gt;
gt; gt; quot;Darren1o1quot; gt; wrote in message
gt; gt; ...
gt; gt; gt; I need a function to check a Column of data and check if it is
quot;Feasiblequot;
gt; gt; or
gt; gt; gt; quot;Unfeasiblequot;. In the next column of data the is measurements. I need
to
gt; gt; get
gt; gt; gt; the measurements of the quot;Feasiblequot; data into of an array.
gt; gt; gt; Eg.
gt; gt; gt; Column a = Feasible?
gt; gt; gt; Column b = Inductance (Tesla)
gt; gt; gt;
gt; gt; gt; Feasible? Inductance (Tesla)
gt; gt; gt; Feasible 1,17621E-06
gt; gt; gt; Feasible 1,59844E-06
gt; gt; gt; Feasible 2,05083E-06
gt; gt; gt; Feasible 2,5937E-06
gt; gt; gt; Feasible 3,16673E-06
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; Should end up with the inductance values in an array if they are
feasible.
gt; gt; gt; Thanks
gt; gt;
gt; gt;
gt; gt;
What i need is to see the values, these are the output of the formulae (the
feasible size numbers for the project) how could i do this?? thanks again

quot;Bob Phillipsquot; wrote:

gt; It returns an array, which is what you aid you wanted. You need to do
gt; something with that array, embed it in another formula.
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;Darren1o1quot; gt; wrote in message
gt; ...
gt; gt; The value in the box then comes up as false.
gt; gt;
gt; gt; quot;Bob Phillipsquot; wrote:
gt; gt;
gt; gt; gt; =IF(A1:A100=quot;Feasiblequot;,B1:B100)
gt; gt; gt;
gt; gt; gt; which is an array formula, it should be committed with Ctrl-Shift-Enter,
gt; not
gt; gt; gt; just Enter.
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; HTH
gt; gt; gt;
gt; gt; gt; Bob Phillips
gt; gt; gt;
gt; gt; gt; (remove nothere from email address if mailing direct)
gt; gt; gt;
gt; gt; gt; quot;Darren1o1quot; gt; wrote in message
gt; gt; gt; ...
gt; gt; gt; gt; I need a function to check a Column of data and check if it is
gt; quot;Feasiblequot;
gt; gt; gt; or
gt; gt; gt; gt; quot;Unfeasiblequot;. In the next column of data the is measurements. I need
gt; to
gt; gt; gt; get
gt; gt; gt; gt; the measurements of the quot;Feasiblequot; data into of an array.
gt; gt; gt; gt; Eg.
gt; gt; gt; gt; Column a = Feasible?
gt; gt; gt; gt; Column b = Inductance (Tesla)
gt; gt; gt; gt;
gt; gt; gt; gt; Feasible? Inductance (Tesla)
gt; gt; gt; gt; Feasible 1,17621E-06
gt; gt; gt; gt; Feasible 1,59844E-06
gt; gt; gt; gt; Feasible 2,05083E-06
gt; gt; gt; gt; Feasible 2,5937E-06
gt; gt; gt; gt; Feasible 3,16673E-06
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt; Should end up with the inductance values in an array if they are
gt; feasible.
gt; gt; gt; gt; Thanks
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt;
gt;
gt;

Select the range where you want to see the results (all of them), then enter
this into the formula bar

=IF(ISERROR(SMALL(IF($A$1:$A$20=quot;Feasiblequot;,ROW($A1 :$A20),quot;quot;),ROW($A1:$A20)))
,quot;quot;,
INDEX($B$1:$B$20,SMALL(IF($A$1:$A$20=quot;Feasiblequot;,RO W($A1:$A20),quot;quot;),ROW($A1:$A
20))))

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Darren1o1quot; gt; wrote in message
...
gt; What i need is to see the values, these are the output of the formulae
(the
gt; feasible size numbers for the project) how could i do this?? thanks again
gt;
gt; quot;Bob Phillipsquot; wrote:
gt;
gt; gt; It returns an array, which is what you aid you wanted. You need to do
gt; gt; something with that array, embed it in another formula.
gt; gt;
gt; gt; --
gt; gt; HTH
gt; gt;
gt; gt; Bob Phillips
gt; gt;
gt; gt; (remove nothere from email address if mailing direct)
gt; gt;
gt; gt; quot;Darren1o1quot; gt; wrote in message
gt; gt; ...
gt; gt; gt; The value in the box then comes up as false.
gt; gt; gt;
gt; gt; gt; quot;Bob Phillipsquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; =IF(A1:A100=quot;Feasiblequot;,B1:B100)
gt; gt; gt; gt;
gt; gt; gt; gt; which is an array formula, it should be committed with
Ctrl-Shift-Enter,
gt; gt; not
gt; gt; gt; gt; just Enter.
gt; gt; gt; gt;
gt; gt; gt; gt; --
gt; gt; gt; gt; HTH
gt; gt; gt; gt;
gt; gt; gt; gt; Bob Phillips
gt; gt; gt; gt;
gt; gt; gt; gt; (remove nothere from email address if mailing direct)
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Darren1o1quot; gt; wrote in message
gt; gt; gt; gt; ...
gt; gt; gt; gt; gt; I need a function to check a Column of data and check if it is
gt; gt; quot;Feasiblequot;
gt; gt; gt; gt; or
gt; gt; gt; gt; gt; quot;Unfeasiblequot;. In the next column of data the is measurements. I
need
gt; gt; to
gt; gt; gt; gt; get
gt; gt; gt; gt; gt; the measurements of the quot;Feasiblequot; data into of an array.
gt; gt; gt; gt; gt; Eg.
gt; gt; gt; gt; gt; Column a = Feasible?
gt; gt; gt; gt; gt; Column b = Inductance (Tesla)
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Feasible? Inductance (Tesla)
gt; gt; gt; gt; gt; Feasible 1,17621E-06
gt; gt; gt; gt; gt; Feasible 1,59844E-06
gt; gt; gt; gt; gt; Feasible 2,05083E-06
gt; gt; gt; gt; gt; Feasible 2,5937E-06
gt; gt; gt; gt; gt; Feasible 3,16673E-06
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Should end up with the inductance values in an array if they are
gt; gt; feasible.
gt; gt; gt; gt; gt; Thanks
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt;
gt; gt;
gt; gt;
Ifthe functions in the freely downloadable file at
home.pacbell.net/beban are available to your workbook

=VLookups(quot;Feasiblequot;,a2:b6,2) array entered into a column long enough to
accommodate the output.

Alan Beban

Darren1o1 wrote:
gt; I need a function to check a Column of data and check if it is quot;Feasiblequot; or
gt; quot;Unfeasiblequot;. In the next column of data the is measurements. I need to get
gt; the measurements of the quot;Feasiblequot; data into of an array.
gt; Eg.
gt; Column a = Feasible?
gt; Column b = Inductance (Tesla)
gt;
gt; Feasible?Inductance (Tesla)
gt; Feasible1,17621E-06
gt; Feasible1,59844E-06
gt; Feasible2,05083E-06
gt; Feasible2,5937E-06
gt; Feasible3,16673E-06
gt;
gt;
gt; Should end up with the inductance values in an array if they are feasible.
gt; Thanks

Bob Phillips wrote...
gt;Select the range where you want to see the results (all of them), then enter
gt;this into the formula bar
gt;
gt;=IF(ISERROR(SMALL(IF($A$1:$A$20=quot;Feasiblequot;,ROW($A 1:$A20),quot;quot;),
gt;ROW($A1:$A20))),quot;quot;,INDEX($B$1:$B$20,SMALL(IF($A$1 :$A$20=quot;Feasiblequot;,
gt;ROW($A1:$A20),quot;quot;),ROW($A1:$A20))))
gt;
gt;which is an array formula, it should be committed with Ctrl-Shift-Enter, not
gt;just Enter.
....

I really don't think you understand the nature of the array the OP
wants. Of course, the OP provided a poor example of what he needs.

gt;gt;gt;gt;gt;quot;Darren1o1quot; gt; wrote in message
gt;gt;gt;gt;gt;gt;I need a function to check a Column of data and check if it is quot;Feasiblequot;
gt;gt;gt;gt;gt;gt;or quot;Unfeasiblequot;. In the next column of data the is measurements. I need

The opposite of feasible is infeasible, not unfeasible.

gt;gt;gt;gt;gt;gt;to get the measurements of the quot;Feasiblequot; data into of an array.
gt;gt;gt;gt;gt;gt;Eg.
....

Replacing your example with

Feasible? Inductance
Feasible 1
Infeasible 2
Feasible 3
Feasible 4
Infeasible 5
Feasible 6

do you want an array like either {1;FALSE;3;4;FALSE;6} or
{1;quot;quot;;3;4;quot;quot;;6}, or do you want an array like {1;3;4;6}? Bob has
provided formulas for both of the former. If you want the latter, then
it requires a volatile OFFSET call.

N(OFFSET(B1:B6,SMALL(IF(A1:A6=quot;Fquot;,ROW(B1:B6)-ROW(INDEX(B1:B6,1,1))),
ROW(INDEX($1:$65536,1,1):INDEX($1:$65536,COUNTIF(A 1:A6,quot;Fquot;),1))),0,1,1))

This can be used as a term in longer formulas, but it can't be nested
very deeply.