simplest Array formula needed

  • Thread starter Thread starter Mudilo
  • Start date Start date
M

Mudilo

dear all,

In col A I have values in col B I have conditions. There
are five rows.

I need to pick the values in order from min to max
ignoring zeros with a single formula for each.

For example
A B
2 Yes
1 Yes
6 No
70 No
3 Yes

The result should be
Row 15 1
Row16 2
Row 17 3

Thank you,
Mudilo
 
Thanks for your input, Dave.

However, it does nothing to ignore zeros. Nor it accounts
for condition in B.

Not trying to offend but it always a good idea to test
what one is going to post.
Thanks again.
Mudilo,
 
I do test my things before posting, but thank you.

Perhaps you should test the usefulness of your "specifications" before
sending a question out. If you have a specification you should write what it
is, not hide it (though now I see what you mean) within some "results" you
are expecting.

Good luck!
 
WHY?
How much did you pay him for his consultation time, spent on your problem ,
which you didn't even take your own time, to fully explain?
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

Thanks for your input, Dave.

However, it does nothing to ignore zeros. Nor it accounts
for condition in B.

Not trying to offend but it always a good idea to test
what one is going to post.
Thanks again.
Mudilo,
 
=SMALL(IF(($B$1:$B$5="Yes")*($A$1:$A$5<>0),$A$1:$A$5),ROW(1:1))

entered with ctrl + shift & enter and copied down until you get an error

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Sorry, did not mean to offend
-----Original Message-----
I do test my things before posting, but thank you.

Perhaps you should test the usefulness of your "specifications" before
sending a question out. If you have a specification you should write what it
is, not hide it (though now I see what you mean) within some "results" you
are expecting.

Good luck!






.
Click to expand...
 
Well put RagDyer :)



RagDyer said:
WHY?
How much did you pay him for his consultation time, spent on your problem ,
which you didn't even take your own time, to fully explain?
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

Thanks for your input, Dave.

However, it does nothing to ignore zeros. Nor it accounts
for condition in B.

Not trying to offend but it always a good idea to test
what one is going to post.
Thanks again.
Mudilo,
Click to expand...
 
RagDyer said:
WHY?
How much did you pay him for his consultation time, spent on your
problem, which you didn't even take your own time, to fully explain?
Click to expand...
....

Temper! Temper!
 
Back
Top