I've been working on this one for a while, but I can't seem to wrap my head around it. I'd love some help.
I currently have a spreadhseet that reads something like this.
Dell Akron 27 Sunday
HP Akron 26 Friday
Canon Canton 24 Sunday
Toshiba Cleveland 21 Monday
Compaq Dayton 20 Wednesday
Essentially, what I want to be able to do is create another sheet with just the rows involving Akron. When I use vlookup, I can only pull the first dat point it comes to. How can I type in a formula to pull all of the data associated with Akron into a separate sheet?
Any suggestions?
Bookmarks