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

Hi, I have a list of image names on a spreadsheet. I would like to map these names on to their corresponding lines on a second spreadsheet. However the image names contain additional text before and after it... Is this possible to do through a vlookup or an alternative way? Many thanks in advance.
Solved by S. J. in 24 mins
Need to combine data from multiple workbooks from varying file folders and paste to one worksheet
Solved by Z. F. in 20 mins
i have data ..one sheet i have all data..if i entered center or village code , i need to get all details of that center..like member names or center name
Solved by Z. J. in 19 mins
wants to calculate yearly salary based on date of joining . I have monthly salary, employee date of joining and my company's financial year end starts from 1-July-2015 and ends on 30-June-2016. now i want a formula which automatically calculate yearly salary for FY 2015-16 for those who joined during the FY and those who worked with company for more than a year. Actually i want this for calculating tax on salary which is based on salary tax slabs.
Solved by B. D. in 21 mins
I need a formula that find the same name and then pulls data from other columns and sheets into a different sheet
Solved by Z. L. in 19 mins
i want to print 97 different excel files containing alike 4 sheets how to print all files in one command
Solved by C. Y. in 18 mins
You are a financial analyst for Williamston Widgets, Inc. The company’s 401(k) provider, the National Bank of Southeast Haslett, has been fired by your CEO for not providing adequate reports to plan participants. She has entrusted you with putting together a workbook with a dashboard that has the following features: 1. A table of all of the 401(k) plan’s available mutual funds, sorted by asset class and style category, that shows the following data points: Fund name, ticker symbol, style category, standard deviation, category rank for the past 1, 3 and 5 years, and expense ratio. 2. Create a Combo Box that contains each available fund, and displays the following data for the fund along with its category average: Fund name, ticket symbol, style category, performance for the past 1, 3 and 5 years, standard deviation, and expense ratio.
Solved by K. H. in 17 mins
I don't know what I pressed, but now my excel worksheet looks like it's grayed out.
Solved by F. F. in 28 mins
We have two spreadsheets of data. One of those sheets has the information arranged in a way that exports to our website. There is one field of data that is missing. We have another report of the same data that has the field we wish to have listed in the report that we export. We can match the data with one field but their are some inconsistencies one report has more data than the other. We want to match the data to correctly add the field of data to the duplicate fields in both reports. HELP?
Solved by F. D. in 23 mins
I will probably need to physically show you to explain what I need.
Solved by F. B. in 22 mins