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

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