What I want to do is the following. I have a worksheet in which I have
created the following; Name-Column , select-Column. I now want to created a
formula in a new sheet which check if the are "x" in the select column and
copy the names of the name-columns to cells in that new sheet. (which is in
the same workbook) is that possible? If so please let me know.

Thanks in advance.

To find a single "x" you would use VLOOKUP(). For all the "x"'s, see:

http://office.microsoft.com/en-us/ex...260381033.aspx
--
Gary''s Student - gsnu201001


"Golf-Iron7" wrote:

What I want to do is the following. I have a worksheet in which I have
created the following; Name-Column , select-Column. I now want to created a
formula in a new sheet which check if the are "x" in the select column and
copy the names of the name-columns to cells in that new sheet. (which is in
the same workbook) is that possible? If so please let me know.

Thanks in advance.

"Gary"s Student;

Thanks for your answer but that is not quit what I was looking for. Maybe I
need to clearly explain what I want to do.

Column B contains "x" values which have been filled in in more than one
cell. (B1;B3;B5 etc) Column A contains Names. (A1;A3;A5 etc.) And now I want
in a different worksheet in the same workbook all the valves of Column A only
if Column B is "x"

The return value needs to be one per cell. So if there are let's say 3 names
each name needs to be returned in a different cell.

I think this can't be done with formules but maybe someone has got an idea.








"Gary''s Student" wrote:

To find a single "x" you would use VLOOKUP(). For all the "x"'s, see:

http://office.microsoft.com/en-us/ex...260381033.aspx
--
Gary''s Student - gsnu201001


"Golf-Iron7" wrote:

What I want to do is the following. I have a worksheet in which I have
created the following; Name-Column , select-Column. I now want to created a
formula in a new sheet which check if the are "x" in the select column and
copy the names of the name-columns to cells in that new sheet. (which is in
the same workbook) is that possible? If so please let me know.

Thanks in advance.

Ok guys the following is the problem I really hope there is someone who can
help.

Sheet 1 contains the following.

Column A Column B
piet x
kees
jan x
joost x
etc

Sheet 2

Column A needs to show all the names in seperate cells which are marked with
a x in sheet 1.


Any idea !?!?!?!?!?!





"Golf-Iron7" wrote:

"Gary"s Student;

Thanks for your answer but that is not quit what I was looking for. Maybe I
need to clearly explain what I want to do.

Column B contains "x" values which have been filled in in more than one
cell. (B1;B3;B5 etc) Column A contains Names. (A1;A3;A5 etc.) And now I want
in a different worksheet in the same workbook all the valves of Column A only
if Column B is "x"

The return value needs to be one per cell. So if there are let's say 3 names
each name needs to be returned in a different cell.

I think this can't be done with formules but maybe someone has got an idea.








"Gary''s Student" wrote:

To find a single "x" you would use VLOOKUP(). For all the "x"'s, see:

http://office.microsoft.com/en-us/ex...260381033.aspx
--
Gary''s Student - gsnu201001


"Golf-Iron7" wrote:

What I want to do is the following. I have a worksheet in which I have
created the following; Name-Column , select-Column. I now want to created a
formula in a new sheet which check if the are "x" in the select column and
copy the names of the name-columns to cells in that new sheet. (which is in
the same workbook) is that possible? If so please let me know.

Thanks in advance.

Hi,

Try this.

Suppose your data is in range A2:B5 on sheet1. On sheet2, type * in cell
C3. In cell D3, enter the following array formula (Ctrl+Shift+Enter) and
copy down

=IF(ISERROR(INDEX(Sheet1!$A$1:$B$5,SMALL(IF(Sheet1 !$B$1:$B$7=$C$3,ROW(Sheet1!$A$1:$A$7)),ROW(Sheet1! 1:1)),1)),"",INDEX(Sheet1!$A$1:$B$5,SMALL(IF(Sheet 1!$B$1:$B$7=$C$3,ROW(Sheet1!$A$1:$A$7)),ROW(Sheet1 !1:1)),1))

Hope this helps.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Golf-Iron7" wrote in message
...
Ok guys the following is the problem I really hope there is someone who
can
help.

Sheet 1 contains the following.

Column A Column B
piet x
kees
jan x
joost x
etc

Sheet 2

Column A needs to show all the names in seperate cells which are marked
with
a x in sheet 1.


Any idea !?!?!?!?!?!





"Golf-Iron7" wrote:

"Gary"s Student;

Thanks for your answer but that is not quit what I was looking for. Maybe
I
need to clearly explain what I want to do.

Column B contains "x" values which have been filled in in more than one
cell. (B1;B3;B5 etc) Column A contains Names. (A1;A3;A5 etc.) And now I
want
in a different worksheet in the same workbook all the valves of Column A
only
if Column B is "x"

The return value needs to be one per cell. So if there are let's say 3
names
each name needs to be returned in a different cell.

I think this can't be done with formules but maybe someone has got an
idea.








"Gary''s Student" wrote:

To find a single "x" you would use VLOOKUP(). For all the "x"'s, see:

http://office.microsoft.com/en-us/ex...260381033.aspx
--
Gary''s Student - gsnu201001


"Golf-Iron7" wrote:

What I want to do is the following. I have a worksheet in which I
have
created the following; Name-Column , select-Column. I now want to
created a
formula in a new sheet which check if the are "x" in the select
column and
copy the names of the name-columns to cells in that new sheet. (which
is in
the same workbook) is that possible? If so please let me know.

Thanks in advance.