Forum Discussion

Chan_Tze_Leong's avatar
Chan_Tze_Leong
Brass Contributor
Feb 10, 2021

Count number of columns with value

I have 3rows x13 columns with the following data: 1 2 3 4 5 6 7 8 9 10 11 12 1 2 3 4 1 5 6 7 8   Usually, I use count (A1 to A12), count (B1:B12) and  count (c1to C12) into 3 cells and use anoth...
excel
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Feb 11, 2021

Chan_Tze_Leong 

- select you area

- in Name Box (top left from the grid) type Range and press Enter

- enter the formula in suitable empty cell

=MAX(MMULT(--(Range<>""),TRANSPOSE(COLUMN(Range)/COLUMN(Range))))

 

Resources