software

Have a column of from 1 to 5 numbers, I would like to use only the first two.
Numbers are located in E16:E20. When I say first two, the two closest to the
top of my column, which starts at E16.

Hoping for help!

Thanks in advance!
Essentially, believe you're asking the same question as your previous post
in mid Jan, re - earlier post / responses at: tinyurl.com/8tx5h

But you didn't feedback further since ..
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
quot;M.A.Tylerquot; lt;Great Lakes Stategt; wrote in message
...
gt; Have a column of from 1 to 5 numbers, I would like to use only the first
two.
gt; Numbers are located in E16:E20. When I say first two, the two closest to
the
gt; top of my column, which starts at E16.
gt;
gt; Hoping for help!
gt;
gt; Thanks in advance!
gt;
gt;
Hi Max, It is close to the same question, and I did try to use some
variations of that formula, without success. By the way that did work well
for my earlier problem! This time I don't think I can use the row numbers, as
they are 16-20. Also I would like to have the entry in the quot;Equot; column come
back as the result. Something like this:

quot;Equot;
16 102
17
18 100
19 99
20 So the result here would be 102 amp; 100

However it could look like this:

quot;Equot;
16 100
17 89
18 99
19 100
20 98 Here the answer should be 100 amp; 89.

Any ideas?quot;Maxquot; wrote:

gt; Essentially, believe you're asking the same question as your previous post
gt; in mid Jan, re - earlier post / responses at: tinyurl.com/8tx5h
gt;
gt; But you didn't feedback further since ..
gt; --
gt; Max
gt; Singapore
gt; savefile.com/projects/236895
gt; xdemechanik
gt; ---
gt; quot;M.A.Tylerquot; lt;Great Lakes Stategt; wrote in message
gt; ...
gt; gt; Have a column of from 1 to 5 numbers, I would like to use only the first
gt; two.
gt; gt; Numbers are located in E16:E20. When I say first two, the two closest to
gt; the
gt; gt; top of my column, which starts at E16.
gt; gt;
gt; gt; Hoping for help!
gt; gt;
gt; gt; Thanks in advance!
gt; gt;
gt; gt;
gt;
gt;
gt;

Adapting from the suggestion to your earlier post ..
here's one way, using non-array formulas ..

Source range is in E16:E20

Put in F16:
=IF(ROW(A1)gt;2,quot;quot;,IF(ISERROR(SMALL($G$16:$G$20,ROW( A1))),quot;quot;,INDEX($E$16:$E$20
,MATCH(SMALL($G$16:$G$20,ROW(A1)),$G$16:$G$20,0))) )

Put in G16: =IF(E16=quot;quot;,quot;quot;,ROW())
Select F16:G16, copy down to G20

F16:F17 will return the required results,
i.e. the topmost 2 numbers other than blanks within E16:E20
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
quot;M.A.Tylerquot; lt;Great Lakes Stategt; wrote in message
...
gt; Hi Max, It is close to the same question, and I did try to use some
gt; variations of that formula, without success. By the way that did work well
gt; for my earlier problem! This time I don't think I can use the row numbers,
as
gt; they are 16-20. Also I would like to have the entry in the quot;Equot; column come
gt; back as the result. Something like this:
gt;
gt; quot;Equot;
gt; 16 102
gt; 17
gt; 18 100
gt; 19 99
gt; 20 So the result here would be 102 amp; 100
gt;
gt; However it could look like this:
gt;
gt; quot;Equot;
gt; 16 100
gt; 17 89
gt; 18 99
gt; 19 100
gt; 20 98 Here the answer should be 100 amp; 89.
gt;
gt; Any ideas?
Alternatively, select F16:F17, put in the formula bar:

=IF(ISERROR(SMALL(IF(E16:E20lt;gt;quot;quot;,ROW(A1:A5)),ROW(A 1:A5))),quot;quot;,
INDEX(E16:E20,MATCH(SMALL(IF(E16:E20lt;gt;quot;quot;,ROW(A1:A5 )),ROW(A1:A5)),ROW(A1:A5),
0)))

Then array-enter the formula (i.e. press CTRL SHIFT ENTER)
instead of just pressing ENTER

F16:F17 would also return the required results
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
Max- Thank you again for your help! Both solutions worked well for my
application.

quot;Maxquot; wrote:

gt; Adapting from the suggestion to your earlier post ..
gt; here's one way, using non-array formulas ..
gt;
gt; Source range is in E16:E20
gt;
gt; Put in F16:
gt; =IF(ROW(A1)gt;2,quot;quot;,IF(ISERROR(SMALL($G$16:$G$20,ROW( A1))),quot;quot;,INDEX($E$16:$E$20
gt; ,MATCH(SMALL($G$16:$G$20,ROW(A1)),$G$16:$G$20,0))) )
gt;
gt; Put in G16: =IF(E16=quot;quot;,quot;quot;,ROW())
gt; Select F16:G16, copy down to G20
gt;
gt; F16:F17 will return the required results,
gt; i.e. the topmost 2 numbers other than blanks within E16:E20
gt; --
gt; Max
gt; Singapore
gt; savefile.com/projects/236895
gt; xdemechanik
gt; ---
gt; quot;M.A.Tylerquot; lt;Great Lakes Stategt; wrote in message
gt; ...
gt; gt; Hi Max, It is close to the same question, and I did try to use some
gt; gt; variations of that formula, without success. By the way that did work well
gt; gt; for my earlier problem! This time I don't think I can use the row numbers,
gt; as
gt; gt; they are 16-20. Also I would like to have the entry in the quot;Equot; column come
gt; gt; back as the result. Something like this:
gt; gt;
gt; gt; quot;Equot;
gt; gt; 16 102
gt; gt; 17
gt; gt; 18 100
gt; gt; 19 99
gt; gt; 20 So the result here would be 102 amp; 100
gt; gt;
gt; gt; However it could look like this:
gt; gt;
gt; gt; quot;Equot;
gt; gt; 16 100
gt; gt; 17 89
gt; gt; 18 99
gt; gt; 19 100
gt; gt; 20 98 Here the answer should be 100 amp; 89.
gt; gt;
gt; gt; Any ideas?
gt;
gt;
gt;

Glad to hear that !
Thanks for the feedback ..
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
quot;M.A.Tylerquot; lt;Great Lakes Stategt; wrote in message
...
gt; Max- Thank you again for your help!
gt; Both solutions worked well for my application.