Hello,
I need to filter the following file.
I need to remove all rows where COL A value and COL B value are the same. COL C does not need to be considered. However I need to retain one of the Col C values for purposes of formatting.
The end result should look similar to columns F,G and H!
Can somebody explain how I do this with advanced filter. (yes i did try google!)
Last edited by ebbo; 02-18-2010 at 11:28 AM.
just select cols a and b
apply advanced filter /filter in place /unique records
then copy the filtered rows somewhere
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
aahhhhhhhhhhhh I see, I did this originally, but didnt notice that some row numbers disappeared on the left (for all duplicates). the file I was working on was 10000+ rows and I was expecting it to be around 1000 after the filter, but the row number still showed 10000 odd figure, so I didnt realise it was actually filtered, until I copied it over to another worksheet.Originally Posted by martindwilson
ty very much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks