Get instant live expert help with Excel and Google Sheets

I have an Excel spreadsheet that has a filter for the months. My problem is that there is a blank space between months on the filter. January February March April How do I clean this up?

I'm trying to make a column that will be 1 if it include certain words and 0 if it includes neither of them.

I have an payment outstanding list. And as i start entering invoice details , the outstanding list should increase and as i get the payments, it should decrease accordingly

There are duplicate values in my pivot table. How do I combine them?

I added the track changes feature to my excel workbook that is shared with my colleagues, and I can longer open excel workbook online.

Employee bonus sheet. Bad debt scoring (line 28) not calculating bad debt correctly (line 58). most likely because they are negative numbers. Please help

I'm currently trying to run the CONCATENATE formula on rows of data. What I need is for the CONCATENATE formula to pick up data in column F and return the result in column G. Problem is that not all data is uniform. For instance there will be data in F4 and F5, nothing in F6, Data in F7, nothing in F8, and data in F9-F11. What I need is for the CONCATENATE formula to group F4 and F5 in G4, group F7 in G7, and group F9-F11 in G9. I need this to repeat until the end of the worksheet. I know a Macro can be created but I'm at a loss of how to make it work. Help please!

Hello! I need some help in Excel formulas.

Hi! I'm trying to figure out a way to build my excel document. What I want is to create a timesheet. The employee would first fill a form with their name, date, the project they are working on, and the time in an out. Then, depending on what project they chose, this info would go in a different sheet but just for this project. And then, there would also be another sheet with a summary of all the projects and how much time as been spent on it. So to resume, I'm looking to have a form, then this info gets transferred to the right sheet depending on the project and finally a summary of how much time was spent on them.

I need a formula to take a number (less than 11 digits) in a cell and change it into an 11 digit text field (zeros prefilling to make 11 digits - no commas or dots)