| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sorting Max values in a column of data
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sorting column data | Excel Worksheet Functions | |||
| Sorting data/time cell values | Excel Worksheet Functions | |||
| Sorting cell data based on values | Excel Discussion (Misc queries) | |||
| Sorting Data in a column | Excel Discussion (Misc queries) | |||
| how do you prevent data from changing values when sorting linked . | Excel Discussion (Misc queries) | |||
Linear Mode
