Get instant chat help with Excel and Google Sheets
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
I have a file with 6 months worth of data and I want to calculate the number of entries in each row that are blank or less than 2. How do I do this
Solved by G. B. in 25 mins
IF(I6<=92,THEN M6*J6/06+J6"")
Solved by S. Q. in 19 mins
Hi! I am trying to set up automatic reminders to be sent to Directors/VP's when they have items that are coming due and/or are past due. Ideally, this would be sent out automatically twice a month, and would only include lines where the Date Returned line was blank. Can this be accomplished with a macro?
Solved by T. W. in 27 mins
I have annual data that I must use drop down check box list to condense and control which years are visible. I have been having difficulty linking the years to a list of combo box because they are a 4 cell merge and run horizontally in a row. I need something similaer as the find option in excel so I can hide and unhide checked years. Also, I couldn't find a dropdown check box list
Solved by T. S. in 30 mins
I am not sure how to use an IF function in order to take a quantity and unit price and add in a discount.
Solved by A. E. in 14 mins
I need a formula that will count a specified range of cells. However the cells that I want counted are made up in a formula format.
Solved by F. E. in 17 mins
I want a formula which will change its value till specific row reach specific vaule.
Solved by S. W. in 14 mins
sum if a amount associated with a category, within a date range.
must tie into the master filters in the SUMMARY sheet.
Solved by S. E. in 25 mins
Hi, I have an excel formula that I have put together but the issue I am having is that the formula runs too slow. The purpose of this document is for the user to create an ongoing list of company names which will have duplicates. The on a separate sheet, it needs to extract only the unique company names from the original list. This would be a working list so this needs to update as company names are being inputted within the 1st sheet.
I have a formula that works correctly, but the problem that is that it slows down the document to the point the document can't be used. The document is calculating the formula each time which is causing the slowness.
Does anyone have a solution for this?
Here is the formula I am using:
=IFERROR(INDEX(TableName,MATCH(0,INDEX(COUNTIF($A$1:A1,TableName),),0)),"")
I hope this makes sense. Any help would be appreciated.
Solved by G. S. in 14 mins
Hi, I need an excel formula that computes a quote for 10 hrs or 5 hrs. I have different rates and cells for the 10hrs and the 5hrs
Solved by T. U. in 17 mins