issue....

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 ????

pierre
Sun May 11 11:40:00 CDT 2008


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

MyVeryOwnSelf
Sun May 11 12:24:57 CDT 2008

> 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.)

T
Sun May 11 12:24:29 CDT 2008

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" <pierre@discussions.microsoft.com> wrote in message
news:02DFAE8E-4F55-436C-B0BB-CC97F9361C1D@microsoft.com...
> 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 ????
>
>