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