Here are some problems that our users have asked and received explanations on
Hello, Excel 2016 Pivot Table drill down function is not working correctly. When I click on a number, I'm getting different total number of records then what appears in the Pivot Table.
Solved by G. H. in 14 mins
I need a function that finds the last number that is smaller than the number current number in a list
Solved by O. A. in 11 mins
My Index function won't resolve in Excel 365. I want the function to return the value at an interesecton of a row or column of a pre-defined array which I have also setup as a named Range. The syntax I am typing is: =INDEX(Db1_Pageviews|$C$7|C$8). here, C7 gives the row number and C8 the column number. Why is Excel not resolving this?
Solved by E. A. in 16 mins
function to calculate the number of pages, for example, click it, it can calculate the number of pages
Solved by K. Y. in 15 mins
Hi, I'm making a shedule calculating number of days with function (row 4) with number of hours/function (row 2). =(G4*G2)+(H4*H2)+(I4*I2)+.... Colum marked PROBLEM How can i get excel to do the same calculation for 2 rows for all functions G to AK. i.e =(G4*G2)+(H4*H2)+(I4*I2) + ... until (AK4*AK2)