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
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
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
If for each row it could be
=COUNTA($A3:INDEX(3:3, 1, COLUMN()-1) )and drag it down.
Please check in attached file.