3LeggedDog
Board Regular
- Joined
- Feb 11, 2006
- Messages
- 149
Does anyone know of a way to sort multiple blocks of data, separated by blank rows, all by the same criterion? In this case, I'd like to be able to sort each block, as shown below, by column G, but the sorts have to be independent of each other...
Thanks,
3LD
Thanks,
3LD
pitching 1871-2005.xls | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
338 | 1967 | willhni01 | Willhite | Nick | 2 | NYN | NL | ||
339 | 1967 | williro01 | Willis | Ron | 1 | SLN | NL | ||
340 | 1967 | wilsodo01 | Wilson | Don | 1 | HOU | NL | ||
341 | 1967 | wiseri01 | Wise | Rick | 1 | PHI | NL | ||
342 | 1967 | woodeha01 | Woodeshick | Hal | 1 | SLN | NL | ||
343 | 1967 | wynnebi02 | Wynne | Billy | 1 | NYN | NL | ||
344 | 1967 | zachach02 | Zachary | Chris | 1 | HOU | NL | ||
345 | |||||||||
346 | 1968 | adamsmi01 | Adamson | Mike | 1 | BAL | AL | ||
347 | 1968 | akerja01 | Aker | Jack | 1 | OAK | AL | ||
348 | 1968 | bahnsst01 | Bahnsen | Stan | 1 | NYA | AL | ||
349 | 1968 | bailest01 | Bailey | Steve | 1 | CLE | AL | ||
350 | 1968 | baldwda01 | Baldwin | Dave | 1 | WS2 | AL | ||
351 | 1968 | barbest01 | Barber | Steve | 1 | NYA | AL | ||
352 | 1968 | beenefr01 | Beene | Fred | 1 | BAL | AL | ||
Sheet1 |