Get instant live expert help on I need help with pivot table course

“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

Hi, this is my problem. I've made an employee training tracker. Table contains a dropdown list of training courses. Only two of those training courses need to be retaken. Course "A" every 4 years, course "D" every 3 years from the date on another column. I need a formula to calculate the new training date for only course "A" and "D" on another column. Could you please help me?
Solved by V. J. in 22 mins
=IFERROR(VLOOKUPSTR(D26,'Pivot Table 2'!B:Q,16,'Pivot Table 2'!B:W,22,'Pivot Table 2'!B:AD,29,'Pivot Table 2'!B:AK,36,'Pivot Table 2'!B:AR,43,0),0)
Solved by I. F. in 30 mins
I have 91 courses. Each course has 45 professors teaching that course. I have to list the course numbers down a column. I need to insert all 45 professors next to each course number. Is there a way to do this besides inserting 45 rows, copying and pasting the 45 professor names and doing it over and over again?
Solved by T. L. in 16 mins
Hi, Need help to get a formula in excel for the same. If a course director/ course faculty (will be a drop down list) who is of a particular category (will be a drop down list) visits the center for either full day/ half day / per hour /absent (will be a drop down list) than what will be his fees(need to reflect in the final answer column. Fees Cadre Full Day Half Day Per Hour Absent Course Director Category A ₹ 1,20,000.00 ₹ 60,000.00 Course Director Category B ₹ 1,00,000.00 ₹ 50,000.00 Course Director Category C ₹ 50,000.00 ₹ 25,000.00 Course Faculty Category A ₹ 20,000.00 ₹ 10,000.00 ₹ 2,500.00
Solved by E. F. in 26 mins
I am having a pivot table problem. The attached file sows the data block and the Pivot Table but there are no Pivot Table Fields for the Pivot Table
Solved by A. W. in 18 mins