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

Hi how do you do a compare of the 2 columns in different spreadsheets and get a result of matches with yes or no. The spreadsheets are large and the column information varies
Solved by I. D. in 12 mins
I have thousands of large "tab-sized" spaces in "blank" cells in my spreadsheet that I cannot find using the Find tool. How can I clear all these spaces without taking many hours doing it manually?
Solved by A. W. in 23 mins
I need a formula for identifying rows that don't have the same cell values in two cells of a large spreadsheet. See attached file.
Solved by E. F. in 29 mins
I need to calculate the chat time (the elapse between the first message and the last message) of a chatbox over a large number of conversations and calculate the mean of the chat duration
Solved by F. Q. in 11 mins
I create pivot tables/charts from data extracted into excel. Each month I have to update the charts - so I extract the data from the software, cut & paste into the file to update the data source for the charts. But - it seems I have to select the data source and highlight the records to be included for each chart, each time I update! I tried to produce a 'dynamic pivot table' without success. Other answers have been when selected the data source select a much large area so you capture the new data pasted into it.... sorry not easy to explain!
Solved by S. U. in 19 mins
I have the following Array; =IFERROR(LARGE(Risk_Score,ROW(1:1)),"") However I only want it to include rows where Risk_Status =Open, I've tried several Large(if( statements but they keep on including rows where Risk_Status is not = to Open.
Solved by D. D. in 15 mins
I SIGNED UP FOR A FREE TRIAL AND WAS TOLD i WOULD BE NOTIFIED WHEN THE TIME HAD ENDED. I NOW HAVE QUITE LARGE AMOUNTS BEING TAKEN FROM MY ACCOUNT.
Solved by F. A. in 16 mins
Hey....complex one...well for me haha...ok so I have a large database at the transport company I work for and what I've been able to extract was the date of revenue trips, what time and departure station...I want to graph all trips from location a on Tuesdays for example vs from location 2 on Wednesdays [we only have 2 locations right now, 7 days of the week of course and departures possible twice an hour]
Solved by S. C. in 19 mins
Want help for IF, OR, AND functions for large data base. Unable to prepare a correct logic with IF, OR, AND function in excel. Please help.
Solved by B. H. in 27 mins
I have a large excel document with many sheets (1 sheet per day) and I need to have a monthly total sheet as well. I am having trouble getting the countifs or countif formulas to work.
Solved by X. U. in 29 mins