Get instant live Excel expert help to learn how to use Large function?

“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 have two very large sets of numerical data on the same excel file but on two different sheets and I need to compare them and highlight any differences. Data Set number 1 is all just in one column, But data set number two is also in one column but there is a lot of other data that is not relevant. I used a pivot table, to sum up all of the numbers I needed in Data set 2 and then I summed up the numbers in data set 1 and there was a difference so I need to have excel highlight that difference
Solved by M. H. in 20 mins
I need to either be able to download an Excel Spreadsheet that handles a changing variable rate, daily interest applied based on date paid and allows for prepayments. I have Excel but have no Excel training. Is their an Excel amortization sheet out there that I can download with those variables? I made a really large loan to family and their interest is based on the changing Prime rate and dates they pay and also they have the ability to make extra payments.
Solved by E. J. in 11 mins
How can I switch between three diferent list in one cell instead of using one very large list
Solved by Z. W. in 11 mins
I need to show the success for a large data set using pivot table and don't know how. Also I need to find a goal using formulas that I don't know
Solved by C. C. in 21 mins
Not sure why my file .csv size is so large .. I have other .csv files that have more data but 10x smaller
Solved by O. J. in 24 mins
Not sure why my file .csv size is so large .. I have other .csv files that have more data but 10x smaller. I need to maybe eliminate something that is making the file so large compare to other .csv i have
Solved by C. A. in 22 mins
Need rank function table help! Set up a table based on my ranking/scoring system. want to rank a large data set based off of my logic
Solved by E. D. in 12 mins
Hi Excel, I have a difficult coding problem that I need some help with. My company has accumulated a giant excel spreadsheet list of potential clients and we are trying to send them personalized letters depending on how large their presence is (how many times their name and address appears in consecutive rows). This is essentially a Mail Merge, but we have set up our format in the visual basics a little differently. Basically, we want to have 1 word document (letter) that will slightly change if a name/address combo appears once, 2 or 3 times, or 4+ times in the excel spreadsheet. However, the big change is when the combo appears 4 or more times because at that point, we want the letter to create an "Exhibit A" that will display all of the information in a different format. Its a complex if/then situation that I have never done. Maybe it needs an additional sub? Generally, the letter will stay the same, keeping the same wording for the first 3 paragraphs. However, after those paragraphs, we would like to add a new paragraph and alter the closing paragraph, in addition to creating the Exhibit A. I'm sure my explanation has left a few unanswered variables, but this is the general dilemma that I am facing. I'd be happy to speak with someone over the phone about this as well. Also, I haven't uploaded a file yet for confidentiality reasons. Thanks!
Solved by V. Q. in 12 mins
I need to delete additive inverse of numbers. For eg. column A contains value 234 and -234. How to delete both values from a large dump of numbers?
Solved by V. L. in 27 mins
I have a large excel spreadsheet that I am trying to format by following the procedures. I simply can not get the page set up right though
Solved by M. Y. in 27 mins