Posted to microsoft.public.excel.worksheet.functions

Maxwell

Posts: n/a

Please explain

Hello Team,
Please excuse my ignorance.
I would like to know what the ampersand and the excliamation marks do or
what are they for?

INDEX(C8:C28,MATCH(D1&" "&MAX((B8:B28=D1)*(D8:D28)),B2:B8&" "&C2:C8,0))

Thank you and best regards

Max

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
counta function can any one explain the example counting 2	pete the greek	Excel Discussion (Misc queries)	4	March 30th 06 10:27 AM
Explain return of #N/A	Biff	Excel Worksheet Functions	12	July 13th 05 08:49 PM
Please Explain Formula	Karen	Excel Worksheet Functions	4	June 16th 05 11:46 PM
Please Explain in Lamen's Terms	Karen	Excel Worksheet Functions	2	June 16th 05 08:52 PM
Explain these please	Sal	Excel Worksheet Functions	1	March 24th 05 08:43 PM

All times are GMT +1. The time now is 11:48 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us