Get instant live Excel expert help to learn how to create and adjust tables in Excel?

Looking to get a formula applied to a pivot table; simple formula that is derived from two columns that can change

I need to create a formula that looks at data in a pivot table and produces a result from that information; as data in the pivot table changes, so should the formula results

I have a (pretty) standard table. days of month at top 1-31... names vertical down the side. I want to have a formula that counts the number of cells that have "voluntary overtime hours" ex: 0430 0530 1530 1630 etc... What is the best formula?

i have multiple State Province with total of mileage. i was to generate a table of the total value of mileage in each state or province

The data in the Excel spread sheet attached needs to be collected into a table and generate a set of charts and graphs in order to expose a possible trend. Then Calculate the mean, standard deviation and Z-scores for each set of seven-day data points. i Need help

WILL PAY FOR 3 SESSIONS I need to loop through Colunm H by date then, see how many 15 minute increments are inbetween Opening/Closing time (column I,J) for each row and divide Column K by amount of 15 minute increments in (Column I,J) and associate the value of each 15 minute block inbetween column (I,J) starting with opening time (Column I) and store the value in an array that sums the total amounts in each 15 minute block. The array will then be pasted to a separate table showing the true amount of sales in each 15 minute block by dividing the total amount of sales by the length of the service by 15 minute blocks. This has to be done with vba and also needs to be able to loop through a full week and also be able to track by 15 minutes from 11am for 24 hours. It must be able to loop through thousands of rows.

WILL PAY FOR 3 SESSION I need to loop through Colunm H by date then, see how many 15 minute increments are inbetween Opening/Closing time (column I,J) for each row and divide Column K by amount of 15 minute increments in (Column J minus I) and store the value in an array that sums the total amounts in each 15 minute block. The array will then be pasted to a separate table showing the true amount of sales in each 15 minute block. This has to be done with vba and also needs to be able to loop through a full week and also be able to track by 15 minutes from 11am for 24 hours. It must be able to loop through thousands of rows.

I've created a table of vertical unique recipe SKUs. In the columns next to those SKUs are the corresponding ingredients, set in their own cells. I'm trying to find out a function for the entire table that I can enter an ingredient and pull up a list of the SKUs that contain that ingredient. Also, is there a way to pull the SKUs for searching for multiple ingredients, i.e. containing chicken and rice? Lastly, is there a way to find the SKUs that DO NOT contain certain ingredients?

Hi My question related to a formula I have a table i want to insert a formula that recognise if anything is above 0 = yes blank = No also want cells with Null to be counted as No inestead of yes . Thank you

What's the easiest way to find the range of the data of two data that contain with the total sales quantity and return sales quantity by simply a click of sale item name (like Pivot Table)?