Forum Discussion
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...
Chan_Tze_Leong I have close to 40 excel files with varying areas. So, to do each row range , is very tedious and time consuming. Imagine, for 1 file, I have to select 10 times for 10 rows. Alternatively, selecting the area is only 1 time activity.
- 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))))
Thank you very much SergeiBaklan
Chan_Tze_Leong , glad to help
