Forum Discussion
Function to return the number of columns which contain information
Hi currently I am using google sheet. I need a function to return the number of columns which contain information (text or number) as in the attached file. is it possible to do that? Thanks
- Sorry it should 5 columns
It depends on which information about number of columns you'd like to have - max number of filled columns for all rows; or for each row separately. And where such output shall be placed.
- information (1,2,3,4,5, Some Arabic words)
Total number of columns should be 30 columns. it may be 15 columns some times.
Columns number or raws should be 120 raws
The output should be placed on the same sheet
