Sorting a list

[kevinkingmd]

Hi all,

I am fairly new to the higher level Excel functions, and I am stuck with this one.

I am trying look at a number of sheets that have about 800 names each. I need to list every person who does not have all "G"s in the fields that follow their names. Then I need to copy the row to a new place or sheet so I can distribute it to the folks in question so they can get some stuff fixed.

NAME 1 2 3 4 5 6 7 8 9 10
Rutherford, Michael G G G A A G G G G G
McQueen, Steve G G G G G G G G G G
Johnnson, Virgil G G G G G G G G G G
Grissom, Gus G B G G G G B G G B
McCain, John G G G G G G G G G G
Schwartzkopf, Norman G G G A A G G G G G

This didn't move over very well, but I figure you can see what I am talking about. Basically, if they don't have all "G"s after their name, i need to get them on a list.

Thanks for your help.

-- Kevin

 

[tactps]

The easy way is to put an extra column at the end, with the formula:
=COUNTIF($C2:$L2,"G") and copy down.
Then do a filter on this new column, highlighting those that are <10.
Copy and paste what is visible.