| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Large function - Please explain
Very well explained. Thanks a lot. HAPPY HOLIDAYS!
"Dave F" wrote: The second formula is looking for the seventh largest number. You have a sequence of 10 numbers, three of which repeat themselves: 3 appears twice, 4 appears three times and 5 appears twice. Thus, in order from smallest to largest you have: 2,3,3,4,4,4,5,5,6,7. Counting from largest to smallest (i.e., from left to right), we see that the seventh digit is 4. On Dec 18, 2:45 pm, Danny wrote: Hi, 1. LARGE({3,4,5,2,3,4,5,6,4,7},3) equals 5 2. LARGE({3,4,5,2,3,4,5,6,4,7},7) equals 4 Please explain why number 2's answer is 4. Thank you |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Large and if function! | Excel Worksheet Functions | |||
| Please explain function/formula | Excel Worksheet Functions | |||
| can someone explain function 'ara'? | Excel Worksheet Functions | |||
| counta function can any one explain the example counting 2 | Excel Discussion (Misc queries) | |||
| IF Function too Large | Excel Discussion (Misc queries) | |||
Threaded Mode
