sort and return column numbers
Thanks for catching my mistake, Max! I'm glad someone is paying
attention... <VBG
If entering the formula in A5, and copying it across, the formula should
be as follows...
=MATCH(LARGE($A$1:$C$1-COLUMN($A$1:$C$1)/10^5,COLUMNS($A$5:A5)),$A$1:$C$1
-COLUMN($A$1:$C$1)/10^5,0)
In article ,
Max wrote:
"Domenic" wrote:
=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)
Perhaps the part: COLUMNS($A$5:B5) in the array above
should be replaced by: COLUMNS($A$1:A1) <g ?
|