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

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 have created a spreadsheet with a dependent data validation drop down list, is there a way that I can copy the validation drop down as I want to use this for each row. If I select Airframe in the 1st row, the dependent drop down will show Fin, Tail, Elevators etc. I might have the row below with Prop which would have a dependent data validation drop down of Blades, Spinner. I want to carry out this task for multiple rows therefore currently I'd use this formula in cell E1 =INDIRECT($B$1) to get the value Airframe from the 1st drop down which will display Fin, Tail, Elevators. For the next row down, I'd need to use =INDIRECT($B$2) and so on for the next row. Is there a way to copy this subtle difference down the rows as it is in the data validation cell?
Solved by X. E. in 26 mins
I have a sheet that I am calculating food macros. I have all of my calculations done. One of my columns is the amount of food allowed. I have another area where I enter the calories allowed. I want to be able to change the calorie intake and have all of my "amount of food allowed" automatically update for me.
Solved by Z. Y. in 18 mins
i need home work excel help who is good in advanced excel and using vba
Solved by F. W. in 11 mins
I have made a time plot in excel (x-axis is hours and y-axis is the cognitive test value). I want to start x-axis from 12:00 PM while excels starts it from 12:00 AM. Guide me please.
Solved by O. C. in 21 mins
i have problem in formula .because i donot understand spreadsheet formulas
Solved by X. H. in 24 mins
I need help looking up a SKU and determine if it is published or not.
Solved by C. J. in 12 mins
I need E4 to show only over 9000 I need E5 to show only over 9000
Solved by C. C. in 20 mins
i need help with my formulas...........value
Solved by C. A. in 27 mins
I have found an error with a formula and i cant work out how to fix it....
Solved by F. A. in 18 mins
I have a long list of donors in a spreadsheet. I have all of their giving records from 2016 and 2017. I need help on formulas so that I can make a report of all the donors who gave in 2016, but not in 2017.
Solved by I. B. in 24 mins