# 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