Get instant online expert help with Excel and Google Sheets

Cannot import my file into an excel chart and format it correctly in a landscape.

I have 7 vans 4*17 seat 3*9 Seat I have a varying number of people to seat into these vans I want the spread sheet to take the total number of people and tell me how many vans I need to take using the least possible

I want to change the colour of a group of cell if a word is matched?

Create a footer with your name on the left side, the sheet name code in the center, and the file name code on the right side of each worksheet.

I have a macro enabled template saved. When opening on one computer one of the cells comes up with 6E+05 instead of auto filling. When the same template is opened on a different computer the error does not come up!

I have a monthly table where the no. of rows varying from month to month i want to make a sum of the sells depends on the condition that the next cell is not empty, and if the cell is empty I want to start a new calculation for the next cells

I have a sheet with info in column A (dates), then info in column B (football teams), then info in column C (other football teams). I want to sort by column A (showing date oldest to newest), then show all the times Team X appears in column B, but then under that show all the times Team X appears in column C. i.e. my raw data is: A1 A2 A3 1/2 X Y 2/2 Z Y 3/2 Y X 4/2 Y Z 5/2 X Z i want it to show: A1 A2 A3 1/2 X Y 5/2 X Z 3/2 Y X 4/2 Y Z 2/2 Z Y

I need a specific account name and value to be pulled from another sheet and imported into Cells C & D. The account name would go into C and the value to D

I have set up a spreadsheet for a small business that accepts 3 different methods of payment. Cash, debit using a debit machine that charges .25 per transaction, and credit cards that charge 2.76% per transaction. My spread sheet is set up with a formula for the credit and debit transactions but I need to be able to enter the amount of sale once in the appropriate column (cash, debit, credit) and have the appropriate total show in the last column using the formula for whichever method. I would really appreciate some help. Thank you!

I would like to make a macro that creates a hotkey to color in my current cell to the last color I used (so the color changes every time I color in a cell in a different color)