Get instant online 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!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I want to count unique values per participant of a study.
Solved by C. Y. in 17 mins
how do i add 20% to a row of figures
Solved by E. Q. in 23 mins
what is the formula to divide a column of numbers by an amount
Solved by X. H. in 11 mins
Hi there looking some help on conditional formatting. the formula I am using is =AND(LEFT(K$4,4)="1350",K9>K34,K5="sell") and it applies to =$K$9:$Z$22. But for some reason it is only working for the row 9 and no others. Could you please assist? I unfortunately cant share the file because it has company information
Solved by A. W. in 18 mins
Sheet Meal 2 1. Column AO, Auto populate the list of names if there is a value of 1 in column C. If no value, ignore. This will show the list of people who will receive the breakfast meal. 2. AR6:BA37 look up values J4:S83 and X20:Z31 (Ingredients in recipe) and only show the match. This will show only the ingredients that a client is allergic to and will ignore the rest.
Solved by I. J. in 20 mins
I need to create charts that clearly show and update data
Solved by K. A. in 11 mins
Trying to extract specific data from spreadsheets. I want to extract just the name and number from the cells that have it, but they are not in linear columns so it looks like I have to do it manually. Is there a way to do it automatically?
Solved by A. A. in 19 mins
if this then that formulas but on a scale.
Solved by B. E. in 14 mins
If column b in tab Top Sheet matches column B in Recibido sheet, return "Recibido" in Top Sheet Column W else If column b in tab Top Sheet matches column B in Evaluado sheet, return "Evaluado" in Top Sheet Column W else If column b in tab Top Sheet matches column B in Aprobado sheet, return "Aprobado" in Top Sheet Column W else If column b in tab Top Sheet matches column B in Entregado sheet, return "Entregado" in Top Sheet Column W else Return "" //blank
Solved by T. B. in 13 mins
Startup capital of 1000 in Cell A1 investment of 200 in Cell A2 Profit/loss (blank) in Cell A3 Closing balance for the day of (800) in A4 How do i use the if function, should i realise a profit of e.g 50 in Cell A3 to give me a closing balance of 1050 in cell A4, without ammending the formula in A4.
Solved by V. H. in 11 mins