Get instant live expert help on max rows in excel 2016

“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

how to sumproduct multiple rows in excel 2016?
Solved by Z. Y. in 28 mins
I need a formula to calculate the MAX of 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
I got the following formula in my latest session: =_xlfn.MAXIFS(Q:Q;C:C;C2) But Excel 2016 does not have the maxifs function anymore, I need some help with changing to MAX(IF(
Solved by G. A. in 23 mins
My Excel 2016 only goes up to 65,536 rows and I need more rows. I thought the specifications 1,048,576 rows? The file name extension is Microsoft Excel Worksheet (.xlsx). Help!
Solved by O. J. in 14 mins
EXCEL 2016 A4 SPREADSHEET BASIC ROWS AND COLUMNS.. ON PREVIEW FILLS PAGE ..WHEN PRINTED LARGE WHITE SPACE AT BOTTOM
Solved by A. A. in 27 mins