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