Find column with maximum rows

B

BatTodor

New member
Joined
Nov 6, 2016
Messages
6
Reaction score
0
Points
0
Excel Version(s)
2012 (Build 13530.20376)
Hi,
Is it possible to find column in table with maximum rows with information (non null or blank)?

Best regards
Todor
 
Nothing simpler than that.
 

Attachments

  • xlguru - count entries per column (PQ).xlsx
    20 KB · Views: 17
Last edited:
And here is the extended query, if you really want to see only the column(s) with the most entries.
 

Attachments

  • xlguru - count entries per column (PQ).xlsx
    23 KB · Views: 14
pinarello said:
And here is the extended query, if you really want to see only the column(s) with the most entries.
Click to expand...

Many thanks pinarello! :)
Your solution is brilliant, thanks again! :)
 
You must log in or register to reply here.
Back
Top