View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Sorting Max values in a column of data

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?