[Guntars]

For example I got this simple table:
___________one___two___three
Name 1______X___________X_
Name 2______X_____X_______
Name 3____________X_______
Name 4______X___________X_
Name 5______X_____X_______
Name 6__________________X_
Name 7______X_____________
Name 8______X_____X_____X_
Name 9____________X_______

How do I tell formula to return all the names from col A:A if the column
€œthree€� has €œX€� in name row?
Thank you
Guntars

[Teethless mama]

First, be patient

Second, use AutoFilter on column three



"Guntars" wrote:

For example I got this simple table:
___________one___two___three
Name 1______X___________X_
Name 2______X_____X_______
Name 3____________X_______
Name 4______X___________X_
Name 5______X_____X_______
Name 6__________________X_
Name 7______X_____________
Name 8______X_____X_____X_
Name 9____________X_______

How do I tell formula to return all the names from col A:A if the column
€œthree€� has €œX€� in name row?
Thank you
Guntars

[Guntars]

Didnt mean to duplicate the question, got the €œservice unavailable€� error
message, and didnt know that message actually got posted.
The result I need to return in different work book, filtering wouldnt work.


"Teethless mama" wrote:

First, be patient

Second, use AutoFilter on column three



"Guntars" wrote:

For example I got this simple table:
___________one___two___three
Name 1______X___________X_
Name 2______X_____X_______
Name 3____________X_______
Name 4______X___________X_
Name 5______X_____X_______
Name 6__________________X_
Name 7______X_____________
Name 8______X_____X_____X_
Name 9____________X_______

How do I tell formula to return all the names from col A:A if the column
€œthree€� has €œX€� in name row?
Thank you
Guntars

[Teethless mama]

For XL-2007:

=IFERROR(INDEX(Name,SMALL(IF(three="x",ROW(INDIREC T("1:"&ROWS(Name)))),ROWS($1:1))),"")

ctrl+shift+enter, not just enter, copy down


All versions:

=IF(ISERR(SMALL(IF(three="x",ROW(INDIRECT("1:"&ROW S(Name)))),ROWS($1:1))),"",INDEX(Name,SMALL(IF(thr ee="x",ROW(INDIRECT("1:"&ROWS(Name)))),ROWS($1:1)) ))

ctrl+shift+enter, not just enter, copy down



"Guntars" wrote:

For example I got this simple table:
___________one___two___three
Name 1______X___________X_
Name 2______X_____X_______
Name 3____________X_______
Name 4______X___________X_
Name 5______X_____X_______
Name 6__________________X_
Name 7______X_____________
Name 8______X_____X_____X_
Name 9____________X_______

How do I tell formula to return all the names from col A:A if the column
€œthree€� has €œX€� in name row?
Thank you
Guntars