Jul 26 2018 08:47 AM - edited Jul 26 2018 09:09 AM
Jul 26 2018 08:47 AM - edited Jul 26 2018 09:09 AM
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 put that formula for 45 times. Thanks in advance!
Formula I am using:
=INDEX(D3:D30000,MATCH(MAX(LEN(D3:D30000)),LEN(D3:D30000),0))