Get instant free 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!”
Here are some problems that our users have asked and received explanations on
hello, I need help calculating the average revenue for every quarters can you please help me
Solved by A. H. in 18 mins
I need to add a "0" in the middle of hundreds od cell entries...
Changing:
303F107M to
303F0107M.
Is this posible without retyping?
Solved by X. U. in 15 mins
I am having a problem with figuring out how to use lookup in excel
Solved by K. H. in 25 mins
Two Sheets: UTI List and Sheet 1
The VLE location in the UTI list mentions in detail the entire addresses with the district names.. all in a single text box. The Sheet 1 mentions all districts to take as reference
I want to:
1)In the VLE Location column, extract the districts into a new column next to the address, if the district names mentioned inside the boxes, match exactly with any district in Sheet 1.
2) Highlight cells that dont match in red
If possible; the cells with text that match closely with the districts, highlights in yellow
Solved by K. U. in 15 mins
I am using the same column for time and date and would like for the date to change but the time to stay the same when I drag to fill in more cells. Is there a way to do this?
Solved by D. B. in 17 mins
How can I tell in Excel VBA when the local computer has timed out and gone dark
Solved by X. B. in 15 mins
Spreadsheet attached: I want to use Index, Match to find the appropriate benchmark values for a given date. My problem is that the date I am searching for is formatted as: MMM-YY and the column I need to search is formatted: 01/01/2017. The spreadsheet I am working with is attached. the first worksheet ("Index Returns") I am trying to fill with values from BSG_Subj_Rtn. If the formats were reversed I could search using Text ...but this does not seem to work when searching an entire column. Any thoughts would be very much appreciated.
Solved by V. U. in 23 mins
create a code to open, close, and save a workbook
Solved by V. C. in 24 mins
I need to create a pie chart from a table. The table will have departments horizontally, and vertically it will have the dates and the two shift times at each date.(7a-7p and 7p-7a) I know how to get to the graph section, I just need it to be able to show the department slices of the pie by the total numbers from all the dates.
Solved by A. E. in 29 mins
I need help assigning family members to a team based on the team other family members are already assigned to
Solved by X. S. in 20 mins