Get instant live expert help on I need help with maximum 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 have a row of measurements and need to find the maximum variance. That is the lowest number divided by the largest number. How can i write this as a formula in excel? Example: 127 111 119 120 126 maximum variance .126 I always have 6 values in the roll and I need to calculate the maximum value for each row and find the maximum number of rows in excel
Solved by T. U. in 21 mins
Hi, I'm using Excel 365 subscription at work. I need to drill down from a cell in my Power Pivot pivot table which has 3,424 records but drilling down returns a truncated sheet of the first 1,000 rows. Clicking the Data ribbon, Existing Connections, then right clicking the relevant query, Edit Connection Properties, shows the OLAP Drill Through but the 'Maximum number of records to retrieve' is greyed out. Could you advise how to return the full number of rows? Thanks
Solved by B. S. in 29 mins
What is the maximum number of trips completed in a 6-hour period throughout the 2 weeks?
Solved by C. L. in 12 mins
Good evening, I'm looking for help with Excel Solver and entering a constraint that will limit a total of 4 cells to a maximum number
Solved by G. Y. in 13 mins
I need help with this excel sheet where it returns rows from raw data. These number of rows being returned are present in a table.
Solved by M. H. in 11 mins