Thanks for the start.. this is waht I was looking for, but I get circular ref
with this formula. Any help?

TIA

"DOR" wrote:

Enter the following formula as an array formula (Shift-Ctl-Enter) in a
cell named Result

=IF(ROW()-ROW(Result)+1COUNTIF(Customer,CustID),"",LARGE((C ustomer=CustID)*Sales,ROW()-ROW(Result)+1))

and copy down for a total of 10 or however many results you want.

Customer is the name of the Customer range in your data, Sales is the
name of the Sales info range and CustID is the cell containing the
entered name.

This should produce a list of the 10 highest values of the Sales info
for the customer, with blanks if the customer has fewer than 10 sales.

HTH