hi guys , please i need your advice on this one :
i have the following given :

A B
1 max 10
2 ralph 20
3 max 30
4 max 40
5 ralph 50

i would like to have the related results of "max" and "ralph"...how can
this be achieved ??? index(...,small(...) ) maybe ??? HOW ????

knowing that my search string is in cell C:C for "ralph" and for "max"
i mean that if i want to enter "ralph" i want results : 20 , 50
and i i want to enter " max" i want results :10 , 30 , 40

See your other post where I make a suggestion that returns the results in a
vertical array. I'm wondering if what you *really* want are the results in a
horizontal array. Be more specific.


--
Biff
Microsoft Excel MVP


"pierre" wrote in message
...
hi guys , please i need your advice on this one :
i have the following given :

A B
1 max 10
2 ralph 20
3 max 30
4 max 40
5 ralph 50

i would like to have the related results of "max" and "ralph"...how can
this be achieved ??? index(...,small(...) ) maybe ??? HOW ????

i have the following given :

A B
1 max 10
2 ralph 20
3 max 30
4 max 40
5 ralph 50

i would like to have the related results of "max" and "ralph"...how can
this be achieved ??? index(...,small(...) ) maybe ??? HOW ????

One way is to use Auto-filter.

First insert a row before row 1. It's a header row (or just a place-holder
for one).

Then select column A and use
Data Filter AutoFilter
This adds a pull-down that lets the user choose which results to display.

(I have Excel 2003.)