Multiple Sort a group of cells on same worksheet

**swieduwi** · 11-20-2008, 10:00 PM

I have been banging my head against the wall on how to sort multiple groups of cells seporatly on same worksheet

I may need a script insted of a formula

**Cheeky Charlie** · 11-21-2008, 09:37 AM

You may need to explain a bit more

CC

**swieduwi** · 11-21-2008, 11:11 AM

ok,
you know how you can sort columns on one page?
I need to sort A6 - D14 as one sort
then A19 - D27 as another sort.
and then A33 - D35 these areas are independent of each other
and are populated from another tab using ='SM!A55 type formulas
everytime I change the data in tab SM the cells on the first tab need to update and sort by points (most points to the top) also these groups
Street Mod, Track Mod and Pro Mod can grow as more racers are added to the roster

See attached sheet above

**Gearcutter** · 11-21-2008, 06:18 PM

Hi,
sorting a table automatically form rankings has one draw back, that is when the ranking is the same for more than one score.Unless you have a second ranking Vlookup or a combination of Index and Match(which I have used on the attachment) will only bring up the first one it comes to. So I have used a countif formula to return a unique rank.
I also had to change one or two other things to accomadate the ranking.
Hope this helps

Regards Howard