Domenic, Thanks. I have formula added and it seems to be woking
--
Sony Luvy


"Domenic" wrote:

First define the following....

Insert Name Define

Name: BigNum

Refers to:

=9.99999999999999E+307

Click

Then try the following formula, which needs to be confirmed with
CONTROL+SHIFT+ENTER...

=LOOKUP(BigNum,CHOOSE(MATCH(TRUE,COUNTIF(INDIRECT( {"B92:AE92","B86:AE86",
"B80:AE80","B74:AE74","B68:AE68","B62:AE62","B56:A E56"}),"<")0,0),B92:A
E92,B86:AE86,B80:AE80,B74:AE74,B68:AE68,B62:AE62,B 56:AE56))

Hope this helps!

In article ,
sony654 wrote:

Biff, I got an error on this function (it just says worksheet function
contains error). And the word COUNT the last time it's displayed below is
highlighted. The function worked until I increased the lookup range to
include b92:ae92 (through b86:ae86 worked). I'm not sure why the error
exists. Please help. And the non-contiguous ranges I'm searching for the
last number displayed are also below.

=IF(COUNT($B$56:$AE$56,$B$62:$AE$62,$B$68:$AE$68,$ B$74:$AE$74,$B$80:$AE$80,$B$
86:$AE$86,$B$92:$AE$92),LOOKUP(1E+100,if(count($B$ 92:$AE$92),$B$92:$AE$92,IF(C
OUNT($B$86:$AE$86),$B$86:$AE$86,IF(COUNT($B$80:$AE $80),$B$80:$AE$80,IF(COUNT($
B$74:$AE$74),$B$74:$AE$74,IF(COUNT($B$68:$AE$68),$ B$68:$AE$68,IF(COUNT($B$62:$
AE$62),$B$62:$AE$62,$B$56:$AE$56))))))),"")

b56:ae56
b62:ae62
b68:ae68
b74:ae74
b80:ar80
b86:ae86
b92:ae92

Thanks for your review and advice.
--
Sony Luvy