View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Derick
 
Posts: n/a
Default best in series macro

In excel office 2003. I am entering a large number of numerical scores for
different individuals plus a few alpha digits NR, DQ etc. I want to sort the
scores in descending order left to right BUT also keep the alpha digits on
the right?
I then want to total the best 12 scores from each individual so as to
produce a positional league table from those totals. Can anyone help !!