Question about the longest cell in excel

[dapenDaniel]

Hi! I have an excel file which has nearly 30000 observations and 45 variables and I would like to find out the longest cell in each column. I know how I can get the longest cell in a specific column. I use the formula as the following below. Is there a single formula that allows me to get the longest cells in each column (for each variable) so that I do not need to find the longest cell column by column. Thanks in advance!





Formula I am using:


=INDEX(D3:D30000,MATCH(MAX(LEN(D3:D30000)),LEN(D3:D30000),0))

 

[dapenDaniel]

I mean Whether there is a formula that allows me to get the longest cells for each variable so that I do not need to put the formula I attached 40 times to find the longest cell for each column.