Question about Functions
 

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

Question about Functions
 

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

Question about Functions
 

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 -

Question about Functions
 

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 -