Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hello,
The best 3 of the first 4: Select 3 cells - for example A4:C4 and array enter: =LARGE(A2:D2,{1,2,3}) The worst 3 of the last 4: Select 3 cells - for example A5:C5 and array enter: =SMALL(E2:H2,{1,2,3}) Array-enter with CTRL + SHIFT + ENTER, not only with ENTER. Regards, Bernd |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Finding Most Recent Values in Col1 -- Summing Matching Values | Excel Discussion (Misc queries) | |||
Finding values | Excel Worksheet Functions | |||
Finding values | Excel Worksheet Functions | |||
finding values and displaying adjacent values | Excel Worksheet Functions | |||
Finding Max values | Excel Worksheet Functions |