View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Matt Matt is offline
external usenet poster
 
Posts: 516
Default Sorting Max values in a column of data

Any way to eliminate the manual 'copy and past' move? I was hoping I could
get the sheet to do this for me.

"Gary''s Student" wrote:

Sort both columns by the #pcs column descending, then copy and paste the top
three cells.
--
Gary''s Student - gsnu200828


"Matt" wrote:

I have two columns of data (one with a part number the other with # of pcs).
I want to post the top (max) three values (# of pcs) along with its
corresponding part number in another section of the worksheet. How do I do
this?