Posted to microsoft.public.excel.worksheet.functions

Harlan Grove[_2_] Harlan Grove[_2_] is offline

external usenet poster

Posts: 1,231

Too many nested IF functions!

"T. Valko" wrote...
Try this:

=INDEX(C4:K4,MATCH(TRUE,INDEX(COUNTIF(C4:K4,C4:K4 )1,1,),0))
....

If willing to work from right to left,

=LOOKUP(2,1/(COUNTIF(C4:K4,C4:K4)1),C4:K4)

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
Nested Functions	Bryan Potter	Excel Discussion (Misc queries)	7	February 22nd 07 09:11 PM
Nested Functions	Toppers	Excel Discussion (Misc queries)	0	February 22nd 07 07:37 PM
More then 7 nested If functions.	Sarah	Excel Worksheet Functions	2	January 4th 07 07:24 AM
Nested functions HELP!	chiefnmd	Excel Worksheet Functions	7	August 25th 05 05:20 AM
nested if(and) functions	Rohan	Excel Discussion (Misc queries)	3	August 12th 05 01:30 AM

All times are GMT +1. The time now is 12:03 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us