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 need help with how to figure out this problem in excel and what function to use. Calculate the sales $ for each month (and total sales $ for the entire year) by make and by model. Months and the yearly total should be labeled across the top of the table; and make and model should labeled down the side of the table.
Solved by X. A. in 24 mins
Solved by V. U. in 17 mins
0 down vote favorite I'm fairly new here and i would like to use help of all excel experts here. So I've run into a problem at work. Situation is I have a table: Row labels: Course names columns labels: Job positions and further sub divided into new and Existing employees. And cell values contains "Yes" for each column and row based on if that job description requires that course, there are more than one courses for each job description. So I want make a another table by getting a values out of above table basis of "Yes", and I want to list the courses by job description. For Example: job Description Courses Clerk courseA Clerk courseB Clerk courseC I have been trying index and match function to get values but not getting any success.
Solved by B. U. in 14 mins
your company helped me provide a graph from an excel spreadsheet and need some more help PLEASE
Solved by V. J. in 15 mins
last night your company helped me excellently putting together a ppt slide from an excel spreadsheet but i need to change a few things please give me to someone who will help the last person cut me off and i have had great experience until then
Solved by B. U. in 14 mins
I'm trying to left align text in Excel. The left-align icon is grayed out. I think it might be because I am trying to left align text in a group of merged cells? I don't know but it's maddening/ Hoping someone can help :)
Solved by X. C. in 25 mins
Hi I would like some help with reconciliation of two columns in excel using VBA. I want to be able to select command button it will look first at value in cell 1,4 cross reference the number with column A if theres a match for both to be coloured in red . then goes to the next cell 2,4 etc.. how do I cross reference the cells? I want to keep it very simple thanks
Solved by S. Q. in 27 mins
I'm trying to do some data analysis on excel and having some trouble. So the problem is I need to make the last consecutive number on a list count but the rest needs to deleted to 0. For example, column A has the first number as a single consecutive number "1" therefore column B's equivalent number stands and is converted to column C as "1". But the next numbers in "A" are 1 and 2, the last consecutive number in this case "2" stands and so column B's equivalent is transferred as 0 to column C but the equivalent for "1" is 0 regardless of what is in column B. Another way of putting this is that if I have in column A 1,2,3 and column B 1,1,1 then column C should have an answer of 0,0,1 as only the last number of a consecutive chain is valid and the others will be converted to 0. So this can be again column A 1,2 and column B 0,0 then column C will be 0,0 because only the last number is taken, coincidentally, this is also 0. Thanks for your help in advance!
Solved by I. J. in 22 mins
I have an excel spread sheet of several thousand entries based on NAICS codes over 8 years. I need to be able to divide each total number by the 0 NAICS code from that year for several hundred entries. What formula will help me to do that?
Solved by V. J. in 14 mins
I have hundreds of coordinates in UTM (distances from the equador parallel and prime meridian in meters) that I need to convert to longitude and latitude to mark in a google earth file. Could you help me with the formula I need to put on excel to convert both columns instantaneously
Solved by F. F. in 30 mins