Thread: =INDEX($B$2:$P$2,COLUMNS(B$2:$P$2))
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Charles Williams Charles Williams is offline
external usenet poster
  
Posts: 968
Default =INDEX($B$2:$P$2,COLUMNS(B$2:$P$2))
Yes thats correct, so as you drag the formula across to the right the
Columns(B$2:$P$2) gives 15, then Columns(C$2:$P$2) gives 14 then 13 etc so
the numbers returned get reversed.

Charles
_________________________________________
FastExcel 2.3
Name Manager 4.0
http://www.DecisionModels.com

"Dave F" wrote in message
...
Can someone explain to me why the above formula will reverse the order
of the contents of columns B:P?

This is my understanding: the COLUMNS(...) portion identifies the
column number in the range B2:P2, and the INDEX(....) portion returns
the contents of the cell corresponding to that column number in the
range B2:P2.

Sound correct?

Thanks,

Dave


Reply With QuoteReply With Quote