Get instant expert help with Excel and Google Sheets

I am working on a Excel worksheet that has a data tab, and another tab for the pivot table. This table is getting data and $ amounts from the data tab (within the same file), however, it's not taking all the data I'm selecting within the pivot table.

I got a math issue in excel. It's about sales where we have scheme. If someone purchase 2 box of product which have 9 items per box which makes it 18 items, and we give them 3 items extra for free. and if a person buys 1 box(9item) then we give them 1 item free. Now I have a problem to calculate how many item were freely given away. I have data of total item sold(including free items). How to do that calculation without any number after decimal.

On an XY Scatter chart, I've got 2x data series plotted against DateTime on the x-axis (Format dd/mm/yyyy hh:mm:ss). When left to it's own devices after selecting my data series, it gives me the x-axis datetime starting from '00/01/1900 00:00:00'. As usual, I've converted the start and end DateTimes into a number format and set those as the axis boundaries. This then displays my x-axis correctly, starting from the start date and ending at the end date, but both my data series disappear from the chart. Do you know what might be causing my data to disappear when I set the x-axis to display properly? Thanks

I have a table (9 rowsX 4 columns). I need to summarise this table using excel formulae. The rule states: "The 'Occupancy Description' of the building (within the location) that has the largest value of the 'Area Sq. Ft' should be the 'Occupancy Description' of the location" This should be done using pure excel formulae (no macros). Do you think you can help?

HI I need help getting a formula together to determine is someone was on time by appointment date and appointment time. but with the appointment time they have a 30 minute window so that also needs to be included in the formula

I want to return all the data with today's date. Like if i have data according to the date.

Hi, I have a range of dates for items which expire. These items conditionally format to flag a colour: In Date Out of Date Out of Date within 14 days Out of Date within 28 days I need to be able to look across the list of dates and put that date into Sheet 1, along with the persons name and the item which is expiring. I need to be able to do that for the three out of date options above, and this needs to be autonomous. My problem is that I can return the first 'out of date' item, but when I want to look across this range again, I want to bypass the first date, because it has already been returned, and find the next out of date item.

I need to be able to list a value based off a lease reference # from one sheet to another and also use the value that is closest to today's date today() without using an array formula.

when i place formula "=C4" on cell C2, while C4 is emply, it shouldn't place '0' on C2

как перемещать строки при использовании "arrayformula" без каких либо ошибок