I 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 Student


"jam" wrote:

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
Jam