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 sheetIf for each row it could be
=COUNTA($A3:INDEX(3:3, 1, COLUMN()-1) )and drag it down.
Please check in attached file.
- But overall there are five columns regardless they are 3 data or 1 or 5 data in each raw. Probably taking the max. number of data element in cells of each raw is useful.
Let me clarify
It shall be as in blue - max number of columns filled for each row. And in which column to place results; or
it shall be as in green - max number of columns filled for entire range. And in which cell result shall be.