View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max
 
Posts: n/a
Default sort and return column numbers

On reflection, perhaps just use RANK might suffice ..

With source numbers in A1:C1

Put in A2, copied to C2: =RANK(A1,$A$1:$C$1)

Ties in the source numbers, if any, will be given duplicate rankings,
with skipped subsequent rankings
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---