Question about Functions

B

brown.kj

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
 
P

Pete_UK

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
 
B

brown.kj

Pete
That helped, thanks man.

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






- Show quoted text -
Click to expand...
 
Top