the following formula:
=IF(B130<>"",MAXA(LEN('Data Sheet'!DY2:DY65536)),"")
produces the answer 6 in the formula palate.
it produces the answer 1 in the cell.
I am trying to determine the maximun width of a range of cells containing both numerical and text data.
Any Suggestions
=IF(B130<>"",MAXA(LEN('Data Sheet'!DY2:DY65536)),"")
produces the answer 6 in the formula palate.
it produces the answer 1 in the cell.
I am trying to determine the maximun width of a range of cells containing both numerical and text data.
Any Suggestions