A B C
D E F G
105 92 DEARHOLT JOSEPH E5 1/11/2008 GMT Yes
106 93 DELACERDA EDGAR E7 1/11/2008 GMT Yes
107 94 DIAZ-KINCAID ELIAS E4 1/11/2008 GMT Yes
108 95 DICKERSON JEFFREY E4 Not Completed No

Above is a cutout of my spread sheet and hopefully it is readable. I
have over 400 names on my list and I would like to basically use a
function to list the people who have a "No" in Column G. So if G108 =
NO then show DICKERSON.


Hopefully someone understands what I am trying to do here and can help
me out. I have been searching all morning to try and get this figured
out but have had no luck.

Thanks,
Ken

Apply autofilter to column G (using Data | Filter | Autofilter), and
then in the filter pull-down select "No" - all the other rows will be
hidden.

Hope this helps.

Pete

On Feb 27, 2:05*pm, " wrote:
* * * A * * * * * * *B * * * * * * * * * * * * * * *C
D * * * * * * *E * * * * * * *F * * * * * * * * * * * *G
105 92 *DEARHOLT * * * *JOSEPH *E5 * * *1/11/2008 * * * GMT * * * * * * * * * * Yes
106 93 *DELACERDA * * * EDGAR * E7 * * *1/11/2008 * * * GMT * * * * * * * * * * Yes
107 94 *DIAZ-KINCAID * *ELIAS * E4 * * *1/11/2008 * * * GMT * * * * * * * * * * Yes
108 95 *DICKERSON * * * JEFFREY E4 * * * * * * *Not Completed * No

Above is a cutout of my spread sheet and hopefully it is readable. I
have over 400 names on my list and I would like to basically use a
function to list the people who have a "No" in Column G. So if G108 =
NO then show DICKERSON.

Hopefully someone understands what I am trying to do here and can help
me out. I have been searching all morning to try and get this figured
out but have had no luck.

Thanks,
Ken

Pete
That helped, thanks man.

Ken

On Feb 27, 9:09*am, Pete_UK wrote:
Apply autofilter to column G (using Data | Filter | Autofilter), and
then in the filter pull-down select "No" - all the other rows will be
hidden.

Hope this helps.

Pete

On Feb 27, 2:05*pm, " wrote:



* * * A * * * * * * *B * * * * * * * * * * * * * * *C
D * * * * * * *E * * * * * * *F * * * * * * * * * * * *G
105 92 *DEARHOLT * * * *JOSEPH *E5 * * *1/11/2008 * * * GMT * * * * * * * * * * Yes
106 93 *DELACERDA * * * EDGAR * E7 * * *1/11/2008 * * * GMT * * * * * * * * * * Yes
107 94 *DIAZ-KINCAID * *ELIAS * E4 * * *1/11/2008 * * * GMT * * * * * * * * * * Yes
108 95 *DICKERSON * * * JEFFREY E4 * * * * * * *Not Completed * No

Above is a cutout of my spread sheet and hopefully it is readable. I
have over 400 names on my list and I would like to basically use a
function to list the people who have a "No" in Column G. So if G108 =
NO then show DICKERSON.

Hopefully someone understands what I am trying to do here and can help
me out. I have been searching all morning to try and get this figured
out but have had no luck.

Thanks,
Ken- Hide quoted text -

- Show quoted text -

You're welcome - thanks for feeding back (seems quite rare these
days!).

Pete

On Feb 27, 2:39*pm, " wrote:
Pete
That helped, thanks man.

Ken

On Feb 27, 9:09*am, Pete_UK wrote:



Apply autofilter to column G (using Data | Filter | Autofilter), and
then in the filter pull-down select "No" - all the other rows will be
hidden.

Hope this helps.

Pete

On Feb 27, 2:05*pm, " wrote:

* * * A * * * * * * *B * * * * * * * * * * * * * * *C
D * * * * * * *E * * * * * * *F * * * * * * * * * * * *G
105 92 *DEARHOLT * * * *JOSEPH *E5 * * *1/11/2008 * * * GMT * * * * * * * * * * Yes
106 93 *DELACERDA * * * EDGAR * E7 * * *1/11/2008 * * * GMT * * * * * * * * * * Yes
107 94 *DIAZ-KINCAID * *ELIAS * E4 * * *1/11/2008 * * * GMT * * * * * * * * * * Yes
108 95 *DICKERSON * * * JEFFREY E4 * * * * * * *Not Completed * No

Above is a cutout of my spread sheet and hopefully it is readable. I
have over 400 names on my list and I would like to basically use a
function to list the people who have a "No" in Column G. So if G108 =
NO then show DICKERSON.

Hopefully someone understands what I am trying to do here and can help
me out. I have been searching all morning to try and get this figured
out but have had no luck.

Thanks,
Ken- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -