“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

- CONDITIONAL FORMATTING
- PIVOT TABLES
- SUMIF
- VLOOKUP
- COUNTIF
- MATCH
- INDEX
- LIVE EXCEL HELP
- ONLINE EXCEL HELP
- EXCEL HELP CHAT
- FREE EXCEL HELP
- EXCEL EXPERT HELP
- IF
- COLUMN
- ROW
- COUNT
- LOOKUP
- AVERAGE
- SUM
- ABS
- BOX AND WHISKER
- PI
- RAND
- CONCATENATE
- IRR
- WORKDAY
- MAX
- SUMPRODUCT
- IF AND
- TEXT
- TIME AND DATE
- RANK
- AVERAGEIF
- PERCENTAGE
- RANGE
- DATA VALIDATION
- ROUND
- TABLES
- SHORTCUT
- DATE SERIES
- MAX AND MIN
- DATABASE
- ENGINEERING
- FINANCIAL
- STATISTICAL
- SMALL
- LARGE
- CHOOSE
- FIND
- SEARCH
- HOW TO

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

YOU JUST HELPED ME ONE HOUR AGO WITH PPT SLIDE LABELING THAT WAS CREATED FROM AN EXCEL SPREADSHEET AND IT TOOK ONLY A FEW MINUTES. NEED HELP ONE MORE TIME/ PLEASE I HAVE A DEADLINE IN 1 HOUR

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