In case of ties...

A5, copied across:

=MATCH(LARGE($A$1:$C$1-COLUMN($A$1:$C$1)/10^5,COLUMNS($A$5:B5)),$A$1:$C$1
-COLUMN($A$1:$C$1)/10^5,0)

....confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!

In article .com,
wrote:

I am a novice in Macro programming.

Can you please tell me how to sort numeric data in a row and return the
column numbers in the descending order of numbers

Ex-

A B C
15 10 14

i need to get the numbers 1,3,2 as the result.