Thread
:
Too many nested IF functions!
View Single Post
#
8
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove[_2_]
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
Harlan Grove[_2_]
View Public Profile
Find all posts by Harlan Grove[_2_]
Too many nested IF functions!