Don
Have you tried subsorting by column D then Subtotalling?

BTW Can your branch of the family not spell. Rowntree has a 'w' <g
Steve


"Don" wrote in message
...
I have a worksheet that has aproximately 1500 rows. The information is
consistant down each column. Column C is populated with category numbers.
The spreadsheet is sorted by this column. There are approximately 75
different category numbers. Column D is populated with route numbers and
column F is populated with sales results. My question is this. How can I
rank each route number on sales, by category? I could physically define
the
range of each category, but if I add or remove lines from a particular
category, my ranges won't work. Is this an array formula begging to be
used?
--
Don Rountree