Filter data

Hia,

I have a really simple question, I just don't know how to explain it easily!

I have a spreadsheet that contains something like this:

transaction_id	sub_id	order_id
102da542eb257e099d615f98fcf65c	1252362	1252344
10232094ce99ad52f94e7713d3fa2f	1252358	1252358
10242062c71c07416210bba1cd34cf	1252355	1252362
102cb7ce3e217b52b2348391fec55a	1252344	1252355
102ada5404f7cbf9a041bcf9c73795	1252340
10224612c44abf14a8897093b54ea6	1252332
1021da950b261f9f9f5cd74f7aef05	1252321
102e4276ccb10d90e78b4253121ced	1252311
etc	etc

As you can see, sub_id and order_id are actually the same thing, but there are less order_id's and they are not in the same order as it's just a list of sub_id's that I need to keep (I also need to keep the transaction_id that is next to the sub_id). So I need to keep collumn transaction_id and sub_id together, and I need to filter those two collumns so that I am only left with transaction_id's and sub_id's if the sub_id is also in the order_id list.

Does that make any sense what-so-ever? (I suspect not) If so, how do I do it?!

Thanks!

EDIT: Quick edit - Office Excel 2007!

use advanced filter either rename order id to subid and use that as criteria or create a new columnwith subid as header and list order ids below it. you can then copy visible rows to somewhere.