Get instant live expert help on I need help with pivot table tips
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
I need help writing a formula on the Tips Table Column "D" - "CC Transactions" that will match/look-up the date on Tips Col "B" to the "Transactions" Tab/Table Col "A" and return the count of Transactions that are NOT = "CASH" - Col "O" in the Transactions Table "Card Entry Methods" Does that make any sense?
Solved by Z. J. in 27 mins
Practise Pivot Tables: Hi , I'm trying to improve my pivot tables skills. Can you please give me simple tips to best allocate fields to the quadrants & then give me a couple of simple pivot tables to create based on the data attached. Many thanks
Solved by M. L. in 16 mins
COLUMN ONE IS GUEST NUMER, COLUMN TWO IS TIPS AMOUNT, I WOULD LIKE TO CALCULATE #50 TIPS TOTAL. THANKS
Solved by B. E. in 19 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
Sheet 3: Calculations Column 1 Employee Names Columns 2-8 Mon-Fri Column 9 Total (for payroll) Rows 1-20 Employee names and total (cc+room charge tips) tip per each day Math: Daily tip pool of CC tips + Room charge tips for that day| divided by all worked hours for the same day.
Solved by F. W. in 24 mins