Get instant live expert help with Excel or 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 do not know how to use excel. Could you help?
Solved by G. A. in 28 mins
i don't know if this is the right place to ask for help but maybe you can help me. I've been tasked with finding out where all our tech hardware is and make an inventory sheet using excel 2013. I have a scanner to scan the bar codes so it can add the serial number automatically to my excel shee, but my problem is that everytime i scan a barcode it goes to the next bottom cell instead of the cell to the right. Scanning is tedious because before scanning i have to choose a cell, then scan the bar code which fills the chosen cell but then right after scanning it goes to the next bottom cell instead of the cell to the right where i have to manually imput an asset tag number. any way i can change that in excel or do you know of any inventory sofware that can help me accomplish what i need to do? I just want to scan the bar code and automatically go to the cell to the right and not the bottom. thanks renan
Solved by K. H. in 29 mins
Look at Column i it won't pull up the value. Please help. The excel sheet and the google sheet are essentially the same. I prefer excel but i included both
Solved by O. J. in 26 mins
I have a test that i need help on. I am having a very difficult time understanding microsoft excel
Solved by A. D. in 21 mins
I exported data from Primavera p6 that include Dates to EXCEL, I'm not able to change the Date fields to date format ... I changed the cell format and No luck ... please help
Solved by D. C. in 20 mins
On the "Input Scores" tab formulas in E and I columns are being used to return 0.5 or 0 value based on C or G value being equal to each other but I want it to return 0 if both are zero. Hope I got this explained right! Thanks in advance for any help. FYI, I am a mid level excel novice.
Solved by D. U. in 12 mins
I have a macro enabled excel file I created for my company. Essentially, it's a huge dump of all parts our company handles and the plan for those parts (PFEP - Plan For Every Part). I programmed 8 macro buttons that, when a part number cell is selected and a button is pressed, it automatically parses all information for that part into a hidden sheet containing a label template, then auto-prints that sheet and rehides it. In our part list, there are multiples of part numbers (for the purpose that we use that specific part at multiple locations - need different plans for them). Right now it is set up so that when one of the duplicates is selected, it only gives the location information for the first part it finds on the way down. It would be really convenient (for those who didn't participate in creating this document) if there was a way it could grab, word-wrap, and concatinate the locations for all duplicates listed into that one cell. I have pictures of file and code for an example sub in vba, and a copy of file ready on hand I could share for a reference for you. Thanks for your help! Basically where it says "1.2 CS" in the picture uploaded, it needs to list all locations. not just the one for in that row selected. I have more pictures. File size limit restricts uploading spreadsheet.
Solved by A. A. in 29 mins
For some wired reason, excel is remembering the last cell it was on from a page when I try to link a cell from another page. For example, I am balancing out a budget and I usually link #'s from one page(will say PAGE X) to another page(PAGE Y). I press = then I go to the other page, highlight the cell I want and then press return and DONE. Now when I do that, it is not linking over to page y. It actually puts the cell i wanted link onto page x on the last cell it was on before I tried to link. Hope this makes sense. If I type it in manually into page Y, it links and works. So confused, need HELP.
Solved by V. E. in 12 mins
After the recent update I'm unable to open files from one drive on my iPad. I open OneDrive, pick the file I want to open, it transfers to excel, says opening file. Then closes the app completely. I have used this for quite a while. I need this for work please help!!
Solved by E. F. in 30 mins
I have made a list/database in excel (screenshot provided), which includes a column for dates, and one for invoice amounts. I would like to set up on a separate sheet (YEARLY TOTALS) a snapshot of each year. I.e. A table with the totals for each year worked so I don't have to keep using the filter function then adding the totals. I know there's a way of doing it but I can't work out the formula. Please help!
Solved by F. L. in 30 mins