Posted to microsoft.public.excel.misc

Dave F[_2_] Dave F[_2_] is offline

external usenet poster

Posts: 187

=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 Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Index Match for 2 columns and one Row	[email protected]	Excel Worksheet Functions	11	September 28th 06 07:50 PM
INDEX function multiple columns & rows	jasebeds	Excel Worksheet Functions	2	August 27th 06 05:41 PM
INDEX() columns first	spxer	Excel Worksheet Functions	9	August 6th 06 12:22 AM
Index Match Two columns Find Last Bottom	henryriver1	Excel Worksheet Functions	4	May 26th 06 04:49 PM
Index/Match from multiple columns	hgopp99	Excel Worksheet Functions	5	January 21st 06 06:13 PM

All times are GMT +1. The time now is 04:49 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us