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

I have an excel sheet that I need linked to various word docs. When I copy the links from excel the word doc won't save and I frequently get an error message on my excel sheet that I don't understand.

Solved by S. H. in 11 mins

I am trying to do a SUMIF calculation and when I hit insert function and then chose SUMIF it brings up 3 things: range, criteria and sum_range. I can properly select the data I want in there (ex: E2:E6) but I want to make it and absolute cell reference and I am using a mac so I highlight it and click command t but a "ding" noise pops up and it doesn't allow me to change it. I am not sure why. I am following along with an excel module program and the instructor does it frequently and it works every time for him. I have attached a file, and the first sheet is empty and the second sheet has the formula I am supposed to put in.

Solved by I. J. in 27 mins

Having problem with macro enabled sheet. The problem consists of out of memory line 7 error which occurs frequently. Can you please check this

Solved by C. Q. in 11 mins

MS excel 2013 frequently shows The File is locked. Try the command again later

Solved by X. J. in 25 mins

To analyze the data with Microsoft Excel software for several sub tasks below:
1.1 Count the number of Product Family for PF12 (using COUNTIF formula).
1.2 Display the name of the customer who most frequently complained (using INDEX formula
with other possible formulas).
1.3 List all complaint types raised by the customer identified in the task 1.2 (using VLOOKUP
formula with other possible formulas).
1.4 Establish four pivot tables in a new sheet called “Executive Summary” for the Customer

Solved by A. B. in 28 mins

HI, I need to verify that a formula I was given is going to work correctly. I have a 200K row spreadsheet and the results are not producing what I expect. In a small file that was used to test the formula, it appears to work. The formula is =SUMPRODUCT(($A:$A=A2)*(B2>$B:$B))+1
I need to take value in A, compare it to value in B, and then in the next column, rank the items in B numerically. However, the values in column A and B frequently change. So there may be results 1, 2, 3 or 1,4,5,3,2 (I will need to sort to get the results in numeric order). I do know sumproduct is an extremely resource intensive formula.. Thank you.

Solved by K. D. in 18 mins

I have Excel for Mac 2011 version 14.7.7
My problem is the Auto save on some of my files saves too frequently. I have an older computer a Mac Book Pro 2010. So every time Auto save happens it takes about 10 seconds. That would be okay if it save even 30 minutes but it seems to save whenever I cut dat from one spreadsheet and paste it into another (which I do a lot).

Solved by D. Q. in 17 mins

I need to count the most frequently lended in states, per lender (ref: Lender Loan Tape Summary, cell B4), for #1-3 most frequently lended states. (cells G9:G11 of "Lender Loan Tape Summary" tab)

Solved by F. S. in 29 mins

I have a column with multiple entries, for example row 1 has A,B,C row 2 has A,B row 3 B,C row 4 A, C and row 5 A, B, C. I need to get the mode for the most frequently occurring text in the column which is from a drop down list

Solved by G. Q. in 29 mins

I have win/loss columns for player stats and I need help using rank and percentile data analysis tool......I want to be able to pull up the player name using vlookup next to the rank and percentile table but I don't know how to do that; please and thank you!

Solved by K. S. in 11 mins