I am using a kendospreadsheet. I want to find the rownumber of last non blank cell for column C.
When i try the =SUMPRODUCT(MAX(($C$1:$C100<>"")*(ROW($C$1:$C100)))) in excel it works.
The same formula does not work in kendospreadsheet.
Please suggest if this is a bug or if formula needs any change to fit the kendospreadsheet.