I use Excel 2007 and am very familiar with the sort function. I use it a lot for multi-level searches. But there is one type of sort that I have never figured out how to do.
I have a database which happens to have baseball statistics. I want to sort all the 2Bmen by games played (highest to lowest) so that the 2Bmen end up at the top of the list. THEN, I want JUST the 2Bmen (those for whom games played at 2b > 0) to sort by, say, bartting average (highest to lowest).
Can anyone tell me:
(a) is this type of sort possible in Excel 2007, and if yes;
Been wanting to figure this out for years. Appreciate any help.