software

Hi
Anyone can solve this problem
I have 2 rows
a b c d e f
46 55 66 46 55 56
I used min fuction it gives me the first 46
I want to to hvae the 2 46 with the names a and d
If can not solve this since it has one criterion
Thanks for any help
JamI suggest that you transpose your data from rows into columns. Filtering can
be applied to column data, but not row data.

In column form, you can just turn on Autofilter and select the 46 values.
--
Gary's Studentquot;jamquot; wrote:

gt; Hi
gt; Anyone can solve this problem
gt; I have 2 rows
gt; a b c d e f
gt; 46 55 66 46 55 56
gt; I used min fuction it gives me the first 46
gt; I want to to hvae the 2 46 with the names a and d
gt; If can not solve this since it has one criterion
gt; Thanks for any help
gt; Jam
gt;
gt;

Hi!

Assume this data is in the range A1:F2

a b c d e f
46 55 66 46 55 56Enter this formulas as an array using the key combination of
CTRL,SHIFT,ENTER in cell A5 and copy across to F5:

=IF(COLUMNS($A:A)lt;=COUNTIF($A2:$F2,MIN($A2:$F2)),I NDEX($A1:$F1,SMALL(IF($A2:$F2=MIN($A2:$F2),COLUMN( $A1:$F1)-COLUMN($A:$A) 1),COLUMNS($A:A))),quot;quot;)

Enter this formula in A6 and copy across to F6:

=IF(A5=quot;quot;,quot;quot;,INDEX($A2:$F2,MATCH(A5,$A1:$F1,0)))

The results will be:

...........A..........B..........C..........D..... .....E..........F..........
5........a...........d............................ ................................
6.......46.........46............................. ..............................

Biff

quot;jamquot; gt; wrote in message oups.com...
gt; Hi
gt; Anyone can solve this problem
gt; I have 2 rows
gt; a b c d e f
gt; 46 55 66 46 55 56
gt; I used min fuction it gives me the first 46
gt; I want to to hvae the 2 46 with the names a and d
gt; If can not solve this since it has one criterion
gt; Thanks for any help
gt; Jam
gt;
Hi Biff
Thanks for your reply
Up to now it still give me an error in formula in $F2,MIN, I do not
know why?
Itrierd to put the foemula in {} it gives error yoo
Thanks for help
Jam
Biff wrote:
gt; Hi!
gt;
gt; Assume this data is in the range A1:F2
gt;
gt; a b c d e f
gt; 46 55 66 46 55 56
gt;
gt;
gt; Enter this formulas as an array using the key combination of
gt; CTRL,SHIFT,ENTER in cell A5 and copy across to F5:
gt;
gt; =IF(COLUMNS($A:A)lt;=COUNTIF($A2:$F2,MIN($A2:$F2)),I NDEX($A1:$F1,SMALL(IF($A2:$F2=MIN($A2:$F2),COLUMN( $A1:$F1)-COLUMN($A:$A) 1),COLUMNS($A:A))),quot;quot;)
gt;
gt; Enter this formula in A6 and copy across to F6:
gt;
gt; =IF(A5=quot;quot;,quot;quot;,INDEX($A2:$F2,MATCH(A5,$A1:$F1,0)))
gt;
gt; The results will be:
gt;
gt; ..........A..........B..........C..........D...... ....E..........F..........
gt; 5........a...........d............................ ................................
gt; 6.......46.........46............................. ..............................
gt;
gt; Biff
gt;
gt; quot;jamquot; gt; wrote in message
gt; oups.com...
gt; gt; Hi
gt; gt; Anyone can solve this problem
gt; gt; I have 2 rows
gt; gt; a b c d e f
gt; gt; 46 55 66 46 55 56
gt; gt; I used min fuction it gives me the first 46
gt; gt; I want to to hvae the 2 46 with the names a and d
gt; gt; If can not solve this since it has one criterion
gt; gt; Thanks for any help
gt; gt; Jam
gt; gt;Post the *EXACT* formula you tried along with the data involved.

Biff

quot;jamquot; gt; wrote in message ups.com...
gt; Hi Biff
gt; Thanks for your reply
gt; Up to now it still give me an error in formula in $F2,MIN, I do not
gt; know why?
gt; Itrierd to put the foemula in {} it gives error yoo
gt; Thanks for help
gt; Jam
gt; Biff wrote:
gt;gt; Hi!
gt;gt;
gt;gt; Assume this data is in the range A1:F2
gt;gt;
gt;gt; a b c d e f
gt;gt; 46 55 66 46 55 56
gt;gt;
gt;gt;
gt;gt; Enter this formulas as an array using the key combination of
gt;gt; CTRL,SHIFT,ENTER in cell A5 and copy across to F5:
gt;gt;
gt;gt; =IF(COLUMNS($A:A)lt;=COUNTIF($A2:$F2,MIN($A2:$F2)),I NDEX($A1:$F1,SMALL(IF($A2:$F2=MIN($A2:$F2),COLUMN( $A1:$F1)-COLUMN($A:$A) 1),COLUMNS($A:A))),quot;quot;)
gt;gt;
gt;gt; Enter this formula in A6 and copy across to F6:
gt;gt;
gt;gt; =IF(A5=quot;quot;,quot;quot;,INDEX($A2:$F2,MATCH(A5,$A1:$F1,0)))
gt;gt;
gt;gt; The results will be:
gt;gt;
gt;gt; ..........A..........B..........C..........D...... ....E..........F..........
gt;gt; 5........a...........d............................ ................................
gt;gt; 6.......46.........46............................. ..............................
gt;gt;
gt;gt; Biff
gt;gt;
gt;gt; quot;jamquot; gt; wrote in message
gt;gt; oups.com...
gt;gt; gt; Hi
gt;gt; gt; Anyone can solve this problem
gt;gt; gt; I have 2 rows
gt;gt; gt; a b c d e f
gt;gt; gt; 46 55 66 46 55 56
gt;gt; gt; I used min fuction it gives me the first 46
gt;gt; gt; I want to to hvae the 2 46 with the names a and d
gt;gt; gt; If can not solve this since it has one criterion
gt;gt; gt; Thanks for any help
gt;gt; gt; Jam
gt;gt; gt;
gt;
Hi Biff
I did exactly the same as you suggested
I put in a new worksheet from a1 to f1 abcdef, and in a2to f2 the
numbers
I copied the same formula that you posted
Still give error
Any help
Thanks
JamHi Biff
I did exactly the same as you suggested
I put in a new worksheet from a1 to f1 abcdef, and in a2to f2 the
numbers
I copied the same formula that you posted
Still give error
Any help
Thanks
Jam