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
). 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:$A 20),""),ROW($A1:$A20))))

and commit with Ctrl-Shift-Enter

--

HTH

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


"SANCAKLI" wrote in message
...
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" wrote in message
...
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
). 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:$A 20),""),ROW($A1:$A20))))

and commit with Ctrl-Shift-Enter

--

HTH

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


"SANCAKLI" wrote in message
...
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" wrote in message
...
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
). 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:$A 20),""),ROW($A1:$A20))))

and commit with Ctrl-Shift-Enter

--

HTH

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


"SANCAKLI" wrote in message
...
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.