Sorting Max values in a column of data
 

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?

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?

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?

Sorting Max values in a column of data
 

This is almost as easy as copy/paste. Say the data in cols A & B is:

part#1 1
part#2 8
part#3 18
part#4 2
part#5 13
part#6 10
part#7 9
part#8 3
part#9 4
part#10 7
part#11 6
part#12 20
part#13 12
part#14 16
part#15 11
part#16 17
part#17 14
part#18 15
part#19 5
part#20 19

In E1 enter:
=LARGE(B:B,ROW()) and copy down

In D1 enter:
=OFFSET($A$1,MATCH(E1,B:B,0)-1,0) and copy down

We see:
part#12 20
part#20 19
part#3 18


The neat thing about this approach is that the further down we copy, the
more we see.

--
Gary''s Student - gsnu200828


"Matt" wrote:

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?

Sorting Max values in a column of data
 

Hello,

An example:
http://www.sulprobil.com/html/sorting.html

Regards,
Bernd