A challenge for a real Excel Expert (Bob Phillips for instance)

Dear Bob,
Thank you very much for your quick and useful reply. Using your formula
below I was able to get the relevant data on a seperate column and use that
column as a source for my drop-down list (validation). The problem, however,
is that I have 25 rows to fill and therefore I need to use your fomula 25
times to define 25 different columns as source for each row. Since I am not
able to attach files here I sent you an e-mail to your address
([email protected]). I hope you got it. If not please let me know
and I will send it to you again. In this e-mail I have attached an excell
table which shows what exactly I am trying to do. Hope you will have a couple
of minutes to help me.
PS: can somebody tell me how I can attach a sample file to be viewable by
the this community.
best regards,

"Bob Phillips" wrote:

> Put A in C1,
> Then select D1:D20 and in the formula bar enter this array formula
>
> =IF(ISERROR(SMALL(IF($A$1:$A$20=C1,ROW($A1:$A20),""),ROW($A1:$A20))),"",
> INDEX($B$1:$B$20,SMALL(IF($A$1:$A$20=C1,ROW($A1:$A20),""),ROW($A1:$A20))))
>
> and commit with Ctrl-Shift-Enter
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "SANCAKLI" <[email protected]> wrote in message
> news:[email protected]...
> > I have a set of data with two columns. The data can repeat itself in both
> > columns. Ex:
> > A 1
> > A 2
> > A 3
> > B 3
> > B 4
> > B 5
> > I want to have the second column(1,2,3,4,5) as the source for a drop down
> > list but I want to be able to limit the values by the data on the first
> > column. Ex. I choose A and the list of possible values should be 1,2 and 3
> > whereas when I choose B the possible values should be 3, 4 and 5. Your
> advise
> > is very much appreciated.
>
>

As a starter, I am not best pleased that you are publishing my email address
to the world. I go to pains to mask it to avoid spam, and you throw that
away and publish it.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"SANCAKLI" <[email protected]> wrote in message
news:[email protected]...
> Dear Bob,
> Thank you very much for your quick and useful reply. Using your formula
> below I was able to get the relevant data on a seperate column and use
that
> column as a source for my drop-down list (validation). The problem,
however,
> is that I have 25 rows to fill and therefore I need to use your fomula 25
> times to define 25 different columns as source for each row. Since I am
not
> able to attach files here I sent you an e-mail to your address
> ([email protected]). I hope you got it. If not please let me know
> and I will send it to you again. In this e-mail I have attached an excell
> table which shows what exactly I am trying to do. Hope you will have a
couple
> of minutes to help me.
> PS: can somebody tell me how I can attach a sample file to be viewable by
> the this community.
> best regards,
>
> "Bob Phillips" wrote:
>
> > Put A in C1,
> > Then select D1:D20 and in the formula bar enter this array formula
> >
> > =IF(ISERROR(SMALL(IF($A$1:$A$20=C1,ROW($A1:$A20),""),ROW($A1:$A20))),"",
> >
INDEX($B$1:$B$20,SMALL(IF($A$1:$A$20=C1,ROW($A1:$A20),""),ROW($A1:$A20))))
> >
> > and commit with Ctrl-Shift-Enter
> >
> > --
> >
> > HTH
> >
> > RP
> > (remove nothere from the email address if mailing direct)
> >
> >
> > "SANCAKLI" <[email protected]> wrote in message
> > news:[email protected]...
> > > I have a set of data with two columns. The data can repeat itself in
both
> > > columns. Ex:
> > > A 1
> > > A 2
> > > A 3
> > > B 3
> > > B 4
> > > B 5
> > > I want to have the second column(1,2,3,4,5) as the source for a drop
down
> > > list but I want to be able to limit the values by the data on the
first
> > > column. Ex. I choose A and the list of possible values should be 1,2
and 3
> > > whereas when I choose B the possible values should be 3, 4 and 5. Your
> > advise
> > > is very much appreciated.
> >
> >
>

Dear Bob,

I sincerely apologize for publishing your e-mail address. I would like to
tell you that I am no expert on the "dangers" of such issues. Since I got
your address from the web, I thought anybody can get it and that is why I did
not hesitate to put it my message. Another reason was to get your
confirmation that your address, to which I sent a detailed message, is
correct.

I would do anything to correct my mistake and prevent any harm to you. I
have been checking other problems lately and see that you are of great help
to many people. The last thing I want is to cause any harm to you and
discourage you from helping people in the future.

I apologize again and I would have understanding if you would not like to
help me after my mistake.
Best regards,

"Bob Phillips" wrote:

> As a starter, I am not best pleased that you are publishing my email address
> to the world. I go to pains to mask it to avoid spam, and you throw that
> away and publish it.
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "SANCAKLI" <[email protected]> wrote in message
> news:[email protected]...
> > Dear Bob,
> > Thank you very much for your quick and useful reply. Using your formula
> > below I was able to get the relevant data on a seperate column and use
> that
> > column as a source for my drop-down list (validation). The problem,
> however,
> > is that I have 25 rows to fill and therefore I need to use your fomula 25
> > times to define 25 different columns as source for each row. Since I am
> not
> > able to attach files here I sent you an e-mail to your address
> > ([email protected]). I hope you got it. If not please let me know
> > and I will send it to you again. In this e-mail I have attached an excell
> > table which shows what exactly I am trying to do. Hope you will have a
> couple
> > of minutes to help me.
> > PS: can somebody tell me how I can attach a sample file to be viewable by
> > the this community.
> > best regards,
> >
> > "Bob Phillips" wrote:
> >
> > > Put A in C1,
> > > Then select D1:D20 and in the formula bar enter this array formula
> > >
> > > =IF(ISERROR(SMALL(IF($A$1:$A$20=C1,ROW($A1:$A20),""),ROW($A1:$A20))),"",
> > >
> INDEX($B$1:$B$20,SMALL(IF($A$1:$A$20=C1,ROW($A1:$A20),""),ROW($A1:$A20))))
> > >
> > > and commit with Ctrl-Shift-Enter
> > >
> > > --
> > >
> > > HTH
> > >
> > > RP
> > > (remove nothere from the email address if mailing direct)
> > >
> > >
> > > "SANCAKLI" <[email protected]> wrote in message
> > > news:[email protected]...
> > > > I have a set of data with two columns. The data can repeat itself in
> both
> > > > columns. Ex:
> > > > A 1
> > > > A 2
> > > > A 3
> > > > B 3
> > > > B 4
> > > > B 5
> > > > I want to have the second column(1,2,3,4,5) as the source for a drop
> down
> > > > list but I want to be able to limit the values by the data on the
> first
> > > > column. Ex. I choose A and the list of possible values should be 1,2
> and 3
> > > > whereas when I choose B the possible values should be 3, 4 and 5. Your
> > > advise
> > > > is very much appreciated.
> > >
> > >
> >
>
>
>