Get instant 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 dont know why I have this issue all the time. I need to keep track of inventory each week. Sheet one is the month overview, and the rest of the sheets are inventory taken that week. The totals taken each week are suppose to automatically correspond with the column on the month overview sheet with =IF(ISBLANK(B15)=TRUE,"",HLOOKUP(B15,'Taken 9-4'!$B$1:$AO$31,30,FALSE)) as the formula. But it never works when I go to create a new week. Can you help me set it up for the whole month? I know to change the B15,'Taken 9-4'!$B$1:$AO$31,30,FALSE to B15,'Taken 9-11'!$B$1:$AO$31,30,FALSE and so on.. but it doesn't work.
Solved by K. F. in 13 mins
Hi there I am getting an error when downloading a excel file from sharepoint which says it cannot connect to a file and to make sure to use the correct web address. Now I cant find where it is connected to that file. I checked connections but out of luck.
Solved by M. E. in 17 mins
2017-08-22T03:30:00 it's a date i want to add 7 days to the day which is 22 in this case without changing the rest i want it to be like that 2017-08-29T03:30:00
Solved by S. C. in 21 mins
Can you help me to create formula that will compute on the workhours, idle hours & In between hours for the ff. names
Solved by B. E. in 19 mins
I need to change numbers in my spreadsheet from 1 to 0 and 2 to 1 etc without doing it to each individual column, how would I do this?
Solved by C. Q. in 30 mins
if condition in excel notice column O in DATA sheet, it must contain QA or office denial only when there is a name in N column. Kindly help
Solved by T. S. in 19 mins
What formula can I use to figure out how to get the answer 16+20-8x3-8=44
Solved by K. W. in 14 mins
A pie chart comparing Transient Rooms Revenue, Group Rooms Revenue and Food & Beverage Revenue totals for Jan 3rd. o Chart Title should be Revenue Sources o Category Labels should be Transient Rooms Revenue, Group Rooms Revenue and Food & Beverage Revenue. o Include “Value” & “Percentage” as data labels o Save the chart as a new sheet called “Chart 2”
Solved by F. F. in 18 mins
Hello requested expert. I need a code for the above attached excel sheet. I want to send automated emails to myself for approaching due dates and medical expiry with the name of the client and account number. Further I would also the mail to include the details of the customer with its name and license number. Kindly help for the following as I'm quite new to this.
Solved by T. Y. in 17 mins
need to find the least lookup value for a bunch of cells on the same row?
Solved by M. L. in 15 mins