Filter your data in M$ Excel
This might be a lamer... Some of you might think. But what can I do? I just knew about it. I only tried this in Excel 2007 and not with any previous versions.
There are actually several ways you could choose to filter your data like by a cell's value, color, font color and icon. What I did was just to filter it by name so for example, you have two cells represnting a key-value pair such as below...
I right click->filter->filter into a cell's value, in this case it's bigme
Now I have all the rows pertaining to bigme
Try it out!