Forum Discussion

ajl_ahmed's avatar
ajl_ahmed
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
Excel for web
office 365
SergeiBaklan's avatar
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.

ajl_ahmed's avatar
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's avatar
    ajl_ahmed
    Iron Contributor
    Nov 04, 2024
    or probably the minimum value of elements in each raw

Resources