Function to return the number of columns which contain information

Question

Hicurrently 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.&nbsp;is it possible to do that?Thanks

detlef_lewin · Answer

ajl_ahmed&nbsp;Why would the result be 4?&nbsp;=COUNTA(3:3)

ajl_ahmed · Answer

Sorry it should 5 columns

sergeibaklan · Answer

ajl_ahmed&nbsp;
It depends on which information about number of columns you'd like to have&nbsp; - max number of filled columns for all rows; or for each row separately. And where such output shall be placed.

ajl_ahmed · Answer

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 rawsThe output should be placed on the same sheet

sergeibaklan · Answer

ajl_ahmed&nbsp;
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.

Forum Discussion

Function to return the number of columns which contain information

Share

Resources