Choose best values in a list

  • Thread starter Thread starter doctorhappy
  • Start date Start date
D

doctorhappy

How can I select the top x number of values in a range of numerical data? For
example a row contains 2,5,10,4,20,10 and I want to know the 4 highest values
(20, 10, 10 and 5 in this example).
Alternatively, is it possible to sort letters in one cell in alphabetical
order? Eg cell contains EBACDABE to be sorted as AABBCDEE...
 
--If you have the numbers 2,5,10,4,20,10 in cell A1:F1 try the below formula
and copy down to 4 cells to return the best values...

=LARGE($A$1:$F$1,ROW(A1))

--You will need to write a user defined function to sort individual
characters of that cell...
 
Back
Top