View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernd P Bernd P is offline
external usenet poster
 
Posts: 806
Default Finding the 3 best values

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