I have a column that contains sale # and another column that has cust names.

How could I get the highest 10 sale #s for a specific customer?

Is this a place for index / match?

TIA

Ben

Sounds like a perfect fit for autofilter

--

Regards,

Peo Sjoblom

"Benjamin" wrote in message
...
I have a column that contains sale # and another column that has cust
names.

How could I get the highest 10 sale #s for a specific customer?

Is this a place for index / match?

TIA

Ben

I would like to avoid re-arranging the data. I just need to have the highest
sale # to come up in a specific cell based on what customer I want.

"Peo Sjoblom" wrote:

Sounds like a perfect fit for autofilter

--

Regards,

Peo Sjoblom

"Benjamin" wrote in message
...
I have a column that contains sale # and another column that has cust
names.

How could I get the highest 10 sale #s for a specific customer?

Is this a place for index / match?

TIA

Ben

autofilter does not rearrange like sort. If simply filters (hides) out the
undesired cells. Then unfilter to be back exactly like you were. TRY it.

--
Don Guillett
SalesAid Software

"Benjamin" wrote in message
...
I would like to avoid re-arranging the data. I just need to have the
highest
sale # to come up in a specific cell based on what customer I want.

"Peo Sjoblom" wrote:

Sounds like a perfect fit for autofilter

--

Regards,

Peo Sjoblom

"Benjamin" wrote in message
...
I have a column that contains sale # and another column that has cust
names.

How could I get the highest 10 sale #s for a specific customer?

Is this a place for index / match?

TIA

Ben

Really looking for something else... I would like to ave the users simply
input a customer name, and a table to fill below with the last 10 sales info.
If I can get the last 10 sale #, I can fill the table.

"Don Guillett" wrote:

autofilter does not rearrange like sort. If simply filters (hides) out the
undesired cells. Then unfilter to be back exactly like you were. TRY it.

--
Don Guillett
SalesAid Software

"Benjamin" wrote in message
...
I would like to avoid re-arranging the data. I just need to have the
highest
sale # to come up in a specific cell based on what customer I want.

"Peo Sjoblom" wrote:

Sounds like a perfect fit for autofilter

--

Regards,

Peo Sjoblom

"Benjamin" wrote in message
...
I have a column that contains sale # and another column that has cust
names.

How could I get the highest 10 sale #s for a specific customer?

Is this a place for index / match?

TIA

Ben

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