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