Get instant live expert help on max number of rows in excel

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I need a formula to calculate the maximum rows in excel as a range of 167 rows in column D, then find the MAX of the next 167 rows in column D and so on continuously through the entire sheet. Example MAX D2:D169, D170:D337, D338:D505 etc...
Solved by I. Q. in 29 mins
Need to return rows of all cells in a single column within an index that matches (1) a range between 2-numbers (or the same min/max number) and (2) a specific text. See file...
Solved by I. J. in 15 mins
Formula for: Max number of days for open ticket (data columns equal number days and a column for status (open, closed). Trying to use Max(if) statement
Solved by A. D. in 26 mins
Need help tweaking a COUNTIF formula.. Max number of arguements
Solved by S. C. in 12 mins
I did a formula ( =MAX(D9,D14,D20,D26,D29)), the max number appears perfectly, but I want the information that appears next to the max number to appear as well. How do I do that? For example , this max formula is also equal to "Instructor Led Training"
Solved by E. H. in 15 mins