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.

Your question is a little confusing to be honest. If you sort the data
descending then the first column will contain the highest number and
not the third column. To sort from right to left highlight the row or
range to sort and choose Data - Sort from the menu under options
select the "Sort left to right" option under orientation then choose
Descending in the sort dialog.

What are you actually trying to accomplish?

actually i am trying to write a macro for the same. I want column
numbers because data is variable and i have to use column numbers for
linking to other tables

I still don't really know what you want to actually do. Are you
looking to create an array containing the column numbers and the
values? If you fully explain what you actually want it will be easier
to get an answer. How will the column numbers be used? Will they be
used in code or in some kind of lookup?

Look at the Rank Excel worksheet function.

Edmund

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.

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.