Forum Discussion

Iron Contributor

Nov 04, 2024

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

Diamond Contributor

Nov 04, 2024

ajl_ahmed

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.

ajl_ahmed

Iron Contributor

Nov 04, 2024

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

SergeiBaklan
Diamond Contributor
Nov 04, 2024
ajl_ahmed

If for each row it could be

=COUNTA($A3:INDEX(3:3, 1, COLUMN()-1) )

and drag it down.

Please check in attached file.
Book444.xlsx12 KB
- ajl_ahmed
  Iron Contributor
  Nov 04, 2024
  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.
  - ajl_ahmed
    Iron Contributor
    Nov 04, 2024
    or probably the minimum value of elements in each raw
SergeiBaklan
Diamond Contributor
Nov 04, 2024
ajl_ahmed

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.