Oh, I'm sorry. I misunderstood the specific requirements. In the case you
describe dq's second suggestion works best. You no longer need the helper
column either.

In the cell where you want the answer to be enter the following formula:
=OFFSET($T$4,MATCH(FALSE,$U$5:$U$12,0)-1,0,1,1)

In cell T4 enter whatever value you want to see if all values are FALSE
("#n/a"). Or add an additional row where the value is always TRUE and the
value in column T of that row is what you want to see if all other values are
FALSE.

This should be what you need.

Bill Horton

"Nikki" wrote:

On Apr 17, 1:30 pm, Nikki wrote:
On Apr 17, 1:10 pm, William Horton

wrote:

Bill,

Thank you for your reply.

<snip

Hope this helps.

Yes, this works great.



Rather, perhaps not. Sorry for the misleading congratulations before.
This formula does work correctly the way you are describing, but I
would like it to do something a bit different. Perhaps I wasn't clear
enough.

I'd like to return the highest lp/cm consistently visualized. In other
words, visualizations starting with 4 lp/cm. If 4 lp/cm isn't
visualized, it should return nothing - "n/a". If 4, 5, and 7 are
visualized, it should return "5". If 5, 6 and 7 are visualized, it
should still return "n/a" because 4 isn't visualized. If 4, 5, 6, 7
are visualized, it should return "7". Make sense?

Thanks again,
Nikki