Sorting by Rank

[ExcelRoy]

Hi Guys,

I have a question if i may

I am looking to sort a list of data on 3 different sheets

Sheet 1 is the "Master List"
Sheet 2 is sorted in Supplier Order
Sheet 3 is sorted in Category Order

Is there a way of sorting the data using the RANK formula but with spaces between each different line

ie.

1 Part123 Brush ABC
1 Part234 Bin ABC

1 Part555 Bucket BBB

1 Part655 Shovel CBD
1 Part333 Fork CBD
1 Part222 Gloves CBD

Hope this makes sense

Thanks

 

[jvanbonn]

I would use a Pivot Table with the Rank as the Report Field (Excel 2007).

 

[ExcelRoy]

Hi,

Thanks, but i think the pivot table wont work, as i designing on 2007 and need it to run on 2003

From what i understand there may be problems in using on a 2003 version?

Thanks