Formula to return last populated column

[Rubber Beaked Woodpecker]

Hi, I'm looking for a formula that will return a reference of the last column that contains a value greater than zero.

Many thanks

RBW

 

[Anthony47]

For example:

=MAX(IF(A1:ZZ30>0,COLUMN(A1:ZZ30),""))

To be confirmed using the combination Contr-Shift-Enter, not Enter alone

This will return the column number of the last column, looking in the first 700 columns of the first 30 lines