Thread: =INDEX($B$2:$P$2,COLUMNS(B$2:$P$2))
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave F[_2_] Dave F[_2_] is offline
external usenet poster
  
Posts: 187
Default =INDEX($B$2:$P$2,COLUMNS(B$2:$P$2))
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