Sorting a list

kevinkingmd

New Member
Joined
Jan 23, 2005
Messages
1
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
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

tactps

Well-known Member
Joined
Jan 20, 2004
Messages
3,460
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.
 

Forum statistics

Threads
1,147,688
Messages
5,742,629
Members
423,745
Latest member
rtaylor1987

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top