View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Jean-Yves[_2_] Jean-Yves[_2_] is offline
external usenet poster
 
Posts: 253
Default sort and column numbers

Hi,

Maybe the RANK function is what your are looking for
Regards
Jean-Yves

wrote in message
oups.com...
i am a novice in programming and am facing the following problem.

A B C
21 20 30

A B C are my columns and 21, 20, 30 the data i have. i need to sort the
data in descending; and i want to also find out the column numbers in
that order (in this case, 3, 1, 2).

thanks.