# 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