rajvivek said ...
I have a spreadsheet in which the 1st row (A1:AL1) has different headers - say Header1, Header2, Header3 etc. The sheet is long till AL100 in which some cells are empty, and some are non-empty.
I want a formula that could tell me in A101:B101 - 1) the name of the column (for example, Header2) which has the highest no. (instances) of non-empty cells and, 2) Total no. of such instances (non-empty cells) of that particular column.
------------------------------------------------------
for developing this solution, I used a named range yRange for data starting from row2 down. And for this illustration, yRange has data in cells A2:L8
No comments:
Post a Comment