Perhaps you can use a helper column.
In cell V5 put the formula =IF(U5=FALSE,0,1)
In cell V6 put the formula =IF(U6=FALSE,0,V5+1)
Copy the formula in cell V6 to cells V7:V12
In whatever cell you want your answer to be put the formula
=OFFSET(T4,MATCH(MAX(V5:V12),V5:V12,0),0,1,1)

This seems to do it for me. If 8 lp/cm and 10 lp/cm are both TRUE it picks
8 lp/cm. If 7 lp/cm and 8 lp/cm and 10 lp/cm are all TRUE it again picks 8
lp/cm. Basically the most consecutive # of TRUES. If there is a tie it
picks the lower value.

Hope this helps.

Bill Horton

"Nikki" wrote:

Hi Group,

I know this can probably be done in Excel many different ways, but I
cannot seem to grasp exactly what needs to be in the formula.

I have 8 checkboxes that link to 8 different cells in a column
(U5:U12). Each checkbox refers to a certain amount of line pairs seen
(4, 5, 6, 7, 8, 9, 10, and/or 12 lp/cm). I would like to return the
highest number of line pairs seen. However, if, let's say, 8 lp/cm
(U9) and 10 lp/cm (U11) can be visualized, but not 9 lp/cm (U10), I
would only like to return "8". (I know this sounds odd)

To further explain: I'd like to return a value corresponding to the
most consecutive TRUE() statements, starting from the top (U5).

Column T is text; Column U is linked from the checkboxes

T U
5 4 lp/cm TRUE
6 5 lp/cm TRUE
7 6 lp/cm FALSE
8 7 lp/cm TRUE
9 8 lp/cm FALSE
----etc-----

Result returned: "5"

In another sheet I used a nested IF() function, but since there are
more than 7, this doesn't work. I'm sure a LOOKUP() function can be
used, but I just can't seem to put it together correctly.

I'd like not to use a two-step nested function if it's avoidable.

Thank you in advance,
Nikki