Hi!

Doesn't account for duplicates.

Duplicates that fall within the "top ten" cause some formulas to crash.

This isn't real easy to do and the Op didn't mention whether duplicates are
a possibility.

Biff

"Infinity" wrote in
message ...

I reconstructured your worksheet and add in some formula but it is a
little complicated and you have to understand how to use the following

- Vlookup
- Hlookup
- Array type of formulas

I haven't tested it yet, so you might want to test the worksheet out
before using my formulas. Please download attached.


+-------------------------------------------------------------------+
|Filename: SalesTop10.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4554 |
+-------------------------------------------------------------------+

--
Infinity
------------------------------------------------------------------------
Infinity's Profile:
http://www.excelforum.com/member.php...o&userid=32725
View this thread: http://www.excelforum.com/showthread...hreadid=528374