Get instant live expert 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 am a university student .And designing a google form+sheet setup for a university purpose. The form will collect data of up to 1.2 k students and then store it to sheet.When I am trying to share it as a public link , I am not able to get how anyone viewing the link will apply required filters to get the needed data.
Solved by T. Q. in 15 mins
Need help sorting by date, but dates are entered in EU format, DD.MM.YYY
Solved by K. U. in 16 mins
I need a formula that take a total amount, which is in cell c37, then times it by .015 and then adds 15. Then, add d2 and a5 and if the results show 400 or more, it will add .10 per every number 400 and above. Once it has done all that, I need it to times 1.2 for the VAT.
Solved by M. S. in 26 mins
I have a amazon file with lots of data they have few lines on each item, but they put quantity on each line even it is for the same 1 item so when I want to subtotal all items it will show me more quantity then the truth, how can i replace all the ones that I don't need with a zero. I will attach a sample here.
Solved by Z. Y. in 16 mins
I need an averageif formula for a set of individual cells rather than a series.
Solved by K. J. in 28 mins
How do you protect one cell in a worksheet so that the formula can not be typed over
Solved by O. A. in 23 mins
I have a workbook with a 4 worksheets. The main worksheet has been copied and split into 4 separate worksheets based on accountability. I need the worksheets to be link so that any changes made on one are carried over to the main sheet and vice-versa.
Solved by O. H. in 21 mins