Finding first instance in an array

Hi all,

A colleague of mine has an issue where he is trying to find and return the first instance of a non 0 in an array of ca60 cells.

At first we thought he may be able to use an nested if statement. but it appears that there are too many cells to be able to do this.

Does anyone know of an elegant solution that we could use?

Many thanks,
Rich

I've passed your suggestion on, many thanks.
Rich

That worked a treat.

Thanks.

Rich