| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to determine the first 6 large numbers from a list?
Does anyone have any suggestions on how to determine the first 6 large
numbers from a list under column A? such as Under column A, there is a list of numbers 11,23,42,32,63,45,76,34,56,34,67,87,45,55,67,65,43 ,45,23,66,... If any number in column A is the first 6 large numbers, then return 1 in B column related to the same row. Does anyone have any suggestions? Thanks in advance for any suggestions Eric |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to determine the first 6 large numbers from a list?
Hi Eric,
Why not Data Filter AutoFilter Top 6 ... ? HTH |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to determine the first 6 large numbers from a list?
One way
Assume numbers running in A1 down Put in B1, array-enter the formula by pressing CTRL+SHIFT+ENTER: =IF(ISNUMBER(MATCH(A1,LARGE($A$1:$A$100,{1;2;3;4;5 ;6}),0)),1,"") Copy B1 down to the last row of data in col A. Adapt the range to suit. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Eric" wrote: Does anyone have any suggestions on how to determine the first 6 large numbers from a list under column A? such as Under column A, there is a list of numbers 11,23,42,32,63,45,76,34,56,34,67,87,45,55,67,65,43 ,45,23,66,... If any number in column A is the first 6 large numbers, then return 1 in B column related to the same row. Does anyone have any suggestions? Thanks in advance for any suggestions Eric |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to determine the first 6 large numbers from a list?
Enter in B1 and drag down as required:
=IF(A1<=LARGE(A:A,6),1,0) Regards, Stefi €žEric€ť ezt Ă*rta: Does anyone have any suggestions on how to determine the first 6 large numbers from a list under column A? such as Under column A, there is a list of numbers 11,23,42,32,63,45,76,34,56,34,67,87,45,55,67,65,43 ,45,23,66,... If any number in column A is the first 6 large numbers, then return 1 in B column related to the same row. Does anyone have any suggestions? Thanks in advance for any suggestions Eric |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to determine the first 6 large numbers from a list?
On Dec 11, 5:45 am, Eric wrote:
Does anyone have any suggestions on how to determine the first 6 large numbers from a list under column A? such as Under column A, there is a list of numbers 11,23,42,32,63,45,76,34,56,34,67,87,45,55,67,65,43 ,45,23,66,... If any number in column A is the first 6 large numbers, then return 1 in B column related to the same row. Does anyone have any suggestions? Thanks in advance for any suggestions Eric You can enter this array formula in B1:B6 range: =LARGE($A:$A,{1;2;3;4;5;6}) Replace the semicolons with columns, and you can use the same formula in B1:G1 range: =LARGE($A:$A,{1,2,3,4,5,6}) This depends on the list separator setting in your regional settings. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to determine the top 5 occurrences from a list of numbers? | Excel Discussion (Misc queries) | |||
| How to determine the frequency of a list of numbers? | Excel Discussion (Misc queries) | |||
| how do search a list of numbers to find what adds up to a large # | Excel Discussion (Misc queries) | |||
| How do I determine which numbers in a list equal a given sum? | Excel Discussion (Misc queries) | |||
| List ? - How do I make information in one cell determine list to u | Excel Worksheet Functions | |||
Linear Mode
