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 a large excel file and one column filled with duplicates. I'd like to find and replace all the cells containing the same long text, but it's unable to replace it.
Solved by V. H. in 20 mins
I have a very large database and want to separate characters as shown on the attached spreadsheet. Also Excel is very slow after working with this large file. Can I clear a cache (or something) to speed it up?
Solved by G. E. in 20 mins
I have a large spreadsheet that needs to be modified. I need to move value from ROW 3 COLUMN H to ROW 2 COLUMN D and the VALUE needs to be FIXED (meaning a set numerical value such as 124) I then need to SORT THE SPREADSHEET FROM HIGHEST VALUE TO LOWEST VALUE IN COLUMN D.
Solved by D. E. in 24 mins
I have a large spreadsheet that needs to be modified. I need to move value from ROW 3 COLUMN H to ROW 2 COLUMN D and the VALUE needs to be FIXED (meaning a set numerical value such as 41, not just a formula) I then need to SORT THE SPREADSHEET FROM HIGHEST VALUE TO LOWEST VALUE IN COLUMN D. Format of the spreadsheet is 1st Row (Agent Contact Info) 2nd Row, Street Address (Not needed) 3rd Row, City, State Zip (Not needed)
Solved by M. H. in 15 mins
So i have a large number of x and y points i need the arctan(y/x) of each point to graph it. I want to know how to write the formula so that it will give each point, without having to write arctan(y1/x1), arctan(y2/x2).... and so on
Solved by M. C. in 29 mins
I have a large range of data, column A has one of 13 possible values (e.g. 1ACTIVE), column B has an ID against it. I want to do a V lookup type of formula, but can't because Vlookup will only bring up the first value for 1ACTIVE. Whereas I want to see all values in relation to 1ACTIVE.
Solved by E. S. in 29 mins
I have a large range of data, column A has one of 13 possible values (e.g. 1ACTIVE), column B has an ID against it. I want to do a V lookup type of formula, but can't because Vlookup will only bring up the first value for 1ACTIVE. Whereas I want to see all values in relation to 1ACTIVE
Solved by E. A. in 21 mins
I have a .csv file with a large amount of data. All data is currently in column A, but each data piece is separated by "|". Can you help to quickly separate the data into columns so that data is sortable/filterable
Solved by F. D. in 12 mins
I am having trouble with formulas not pulling data from sheet into a second sheet. Can you assist? I have a file, but it is too large to share!
Solved by O. U. in 29 mins
Need help applying conditional formatting to entire row, highlight the entire rows for top five highest positive and top five highest negative % change values . You will need to use LARGE and SMALL functions .
Solved by X. U. in 12 mins