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!”
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