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

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)

Solved by X. C. in 21 mins