Front Office Football Central

Front Office Football Central (https://forums.operationsports.com/fofc//index.php)

- Off Topic (https://forums.operationsports.com/fofc//forumdisplay.php?f=6)

- - Excel Question (https://forums.operationsports.com/fofc//showthread.php?t=84912)

Ben E Lou

09-13-2012 02:37 PM

Excel Question

If a value is eliminated in a particular column, I want to eliminate all rows containing that row. It's not the "Remove Duplicates" feature, because that one, as far as I can tell, leaves one row there. In other words, I want to eliminate any AddressIds that exist more than once. I would want this:

AddressID	Lastname
1	Jones
2	Smith
3	Johnson
4	Johnson-Smith
4	Johnson
5	Williams
6	Lewis
7	Jackson
7	Jackson
7	Jackson

to come out as this:

AddressID	Lastname
1	Jones
2	Smith
3	Johnson
5	Williams
6	Lewis

Passacaglia

09-13-2012 02:51 PM

Not sure if this is the most efficient way, but:

in Column C, put

=countif($a$2:$a$11,a2)

And paste that down. Sort Column C, and remove everything greater than 1.

Suburban Rhythm

09-13-2012 02:55 PM

Quote:

Originally Posted by Passacaglia (Post 2714415)

Not sure if this is the most efficient way, but:

in Column C, put

=countif($a$2:$a$11,a2)

And paste that down. Sort Column C, and remove everything greater than 1.

This was going to be my answer...pretty sure we had a similar Excel question in the past that was solved this method.

Suburban Rhythm

09-13-2012 02:56 PM

Dola

PING Excel gurus - Front Office Football Central

Ben E Lou

09-13-2012 02:58 PM

Yup. That did it. Thanks!

All times are GMT -5. The time now is 05:01 PM.