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
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.