09-13-2012, 02:37 PM | #1 | ||||||||||||||||||||||||||||||||||||
Morgado's Favorite Forum Fascist
Join Date: Oct 2000
Location: Greensboro, NC
|
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:
to come out as this:
__________________
The media don't understand the kinds of problems and pressures 54 million come wit'! |
||||||||||||||||||||||||||||||||||||
09-13-2012, 02:51 PM | #2 |
Coordinator
Join Date: Oct 2000
Location: Big Ten Country
|
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. |
09-13-2012, 02:55 PM | #3 | |
Pro Starter
Join Date: Jan 2002
Location: Pittsburgh
|
Quote:
This was going to be my answer...pretty sure we had a similar Excel question in the past that was solved this method.
__________________
"Do you guys play fast tempos with odd time signatures?" "Yeah" "Cool!!" |
|
09-13-2012, 02:56 PM | #4 |
Pro Starter
Join Date: Jan 2002
Location: Pittsburgh
|
__________________
"Do you guys play fast tempos with odd time signatures?" "Yeah" "Cool!!" |
09-13-2012, 02:58 PM | #5 |
Morgado's Favorite Forum Fascist
Join Date: Oct 2000
Location: Greensboro, NC
|
Yup. That did it. Thanks!
__________________
The media don't understand the kinds of problems and pressures 54 million come wit'! |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
Thread Tools | |
|
|