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